cancel
Showing results for 
Search instead for 
Did you mean: 

BW Virtual Cube result error

Former Member
0 Kudos

Hi,experts:

I encounter a problem that when I check data in my Virtual Cube with 3.X infosource,I can see a lot of data,list here

CALDAY CALMONTH CALYEAR AMOUNT CURR

20090101 200901 2009 100.00 USD

20090701 200907 2009 127.00 USD

20100501 201005 2010 155.57 USD

When I use the selection screen to select the data by restriction,for example CALYEAR 2009.

2 type of result

the first,nothing will be shown.

the second,all the data be shown.

But if i use 0CALDAY as a condition,the result is all right as expected.

20090101 200901 2009 100.00 USD

Who can tell me why??

Best Regards

Martin Xie

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Martin,

BW Automatically aggregates data to 0CALMONTH, which is why you are seeing the 2nd record, which is summation of the 2 2009. Check the external source for the nothing line, which I think isn't much of bother (you can use BEx restrict function to disable the "#' records).

The 0CALDAY included in query provides the output in the granular level. Depending on the expected grain(granularity) of data expected, you can choose the date/month.

Hope it explains.

Thanks

Sam

Former Member
0 Kudos

Hi.SAM:

I create 0CALMONTH in the Infosource and in the cube,when displaying data of the cube, i can see the 0calmonth with data,but if i use slection condition on 0calmonth,nothing will be shown or all will be shown.

Best Regards

Martin Xie

Answers (0)