on 02-01-2008 2:50 PM
Hi all,
I have 1 characterstic " Numeric Month" and 1 keyfigure "Sales Volume" in my cube.
In query designer, I have created a new selection "Cummulative Sales Volume" for "Sales Volume" in which I just mentioned "Sales Volume" in key figure and ticked "Cummulative" in "Calculations" tab so that if month is 2 then "Cummulative Sales Volume" is the sum of month1 and month2.
Now in analyzer, my ouptput is .
Numeric Month Sales Volum Cummulative Sales Volume
1 9,800 9,800
2 11,100 20,900
3 11,500 32,400
4 10,045 42,445
5 10,025 52,470
6 10,200 62,670
7 9,700 72,370
8 9,750 82,120
9 9,890 92,010
10 9,140 101,150
11 9,050 110,200
12 9,050 119,250
Now the problem is that when i extract this query in VC and mentioned formula " DSTR(NOW(),'MM')" for numeric month , it shows following output:
Numeric Month Sales Volum Cummulative Sales Volume
2 11,100 11,100
instead of
Numeric Month Sales Volum Cummulative Sales Volume
2 11,100 20,900
Why it is happenning? If in query output, it shows sum in "Cummulative Sales Volume" then why not in VC ??
Please respond as it is urgent.
Regards,
Aisha Ishrat
ICI Pakistan Ltd.
Aisha,
Check these links.
Also once you limited your query in VC with a NOW() you should test different combinations between this formula and BI Integration Wizard.
http://help.sap.com/saphelp_nw04s/helpdata/en/26/64fb472a144a0dbaf88f5ec75d9270/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/8c/9bf879b21842c7a0f9bebf4aad8659/frameset.htm
Regards,
GilsonTeixeira
Consultant, SAP BI 7.0
Mobile: (55 11) 8335-5061
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gilson,
Yeah I know , if i display the whole query output , its giving correct result. But If i fix the query for current month i.e. now() then it should display the correct cummumative value of that month but it is not.
I need it as i have to show the current YTD amount. Got my point? I have also sent you the screen shots.
Best Regards,
Aisha Ishrat
ICI Pakistan Ltd.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.