This website is not affiliated with, sponsored by, or approved by SAP AG.

Query interval based on input date user

Business Warehouse

Moderators: Snowy, thx4allthefish

Query interval based on input date user

Postby dwainchang » Thu May 03, 2012 8:11 am

Hi all,
In my cube I have a base date and in my query I ask the user to submit an end date.
In my query I want to create intervals , for example, interval 1 : days 0 - 30, interval 2 days 31 - 60
I calculate the number of days between base end user input .
Does anyone know how I can use this number to restrict my intervals..
for example is the number of days between begin and end date is 45, my characteristic should be restricted an appear in interval 2

gr,
dwain
dwainchang
 
Posts: 1
Joined: Thu May 03, 2012 8:02 am

Re: Query interval based on input date user

Postby Gothmog » Thu May 03, 2012 8:13 am

Moved from Financials.
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1941
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 2 guests



cron


loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.