on 09-15-2010 1:49 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
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.