Urgent : Query on Non cumulative cube

[former_member338469]

Dear BI Experts,

I have a non cumulative cube to help me report Stock Balance. It has stock entries from Jan till June,2006. When I query on the cube to report the balance as of Current Period (July,2006) it doesnot return anything. What I expected is that it would show me current stock balance (from Jan till June,2006) though my selection date is in July where there is new stock update done in July.

I tried compression on the cubes as well but didnot change the result.

Can anybody help.

Kind regards,

priyadarshi

[Former Member · Accepted solution]

Hi priyadarshi,

I think you have a problem on validy area of your cube.

In Cube detail check Extras --> Maintain non-cumulative values. Also check the values with Tcode RSDV, if they are correct with your query requirements.

Ciao.

Riccardo.

[former_member338469 · Accepted solution]

Hi Riccardo,

Thanks for your very useful answer. I have "Company" , "SetOfBooks" , "Material" & "0CALDAY" in my validity table. Here For every combination I see a record in the validity table with "Fixed To Time" set with the last transaction dates for the combination. But I would like to preset the "Fixed To Time" for each record to some value like "31-12-9999" .

Should this be possible & how ?

Regards,

priyadarshi

[Former Member · Accepted solution]

Hi,

really sorry but I have not BW system in this moment.

Take a look at notes: 586163 - 360249.

Do not use 31-12-9999, but at least fix the date at the next week, also if it is better to use only the actual period.

Look also these documents in www.service.sap.com/bi: Non-Cumulative Values 3.x - How to… Handle Inventory Management Scenarios in BW.

Ciao.

Riccardo.