cancel
Showing results for 
Search instead for 
Did you mean: 

VC Issue - Urgent

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

Thanks Gilson. I have resolved that myself. But thanks for your time.

Regards,

Aisha Ishrat

ICI Pakistan Ltd.

Former Member
0 Kudos

Aisha,

I could not help you more. I am quiet busy down here in Brazil. Could you please post your solutions so others can access them?

Regards,

Gilson

Former Member
0 Kudos

I just moved characterstic 'Numeric Month' in free characterstics.

Regards,

Aisha Ishrat

ICI Pakistan Ltd.