on 10-08-2007 4:04 PM
Hi Experts -
I have a structure in my query with 3 selections for the 3 previous months' figures including the current month. However I need that for only one of the key figures. I have the key figure for this in a Key Figure structure. But I need to display other key figures in the query but they don;t need the 3 months data. If I include other key figures, all key figures show the 3 months data.
How can I solve this? Please help!
Hi,
you can't.....
You'll have to dfine your key figures selection separately, let's say
- you define "sales value" for the three months
- and "sales budget" only for one period
The above structure will have 4 elements defined...
hope this "helps"...
Olivier.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Bhanu and Olivier!
I created a RKF with billed qty and calendar year/month. i'm using a text variable for the calendar year/month. I created a golbal RKF on the left hand side and dragged it into the query. The description is like this: &Variable_Name& because I need a user input for the month and based on that it'll display that month and the prev 3 months.
But I'm getting an exception when I bring it up in analyzer!
Please let me know what I'm doing wrong!
Hi Syed,
Instead of creating a structure, create 3 restricted key figure for the key figure where you want 3 months of data. You can do this either in the query, or on the left hand side as global RKFs and then pull them into your query.
Hope this helps...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.