on 09-18-2014 5:50 AM
Hi All
I have created one MP on inventory cube and budget cube. But data only coming for inventory cube only in sap bex query. common identification is material and 0fiscper. Here I am sending 0calenderday as posting date to query as input, calculating YTM for budget. Calenday is part of inventory, so I have fiscper is common values. Lets look below example.
calendar date: 17.09.2013
Budget YTM : I need for 09, 10, 11,12 months means till year end. I am calculating stock for the previous months till year start. And checking how much budget I have for future. I am getting stock YTD., not getting budget YTM., Am I missing any thing here ???
Regards
swetha
hi,
the 0calday should not be in the global filter, it should be used in dummy kf, if you need to input some date for KF calculation. If 0calday is in global filter then the whole data is restricted to those values and as 0calday is not present in budget cube,hence the data is getting filtered out.
regards,
Arvind.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are you putting 0CALDAY as characteristic restriction? Is 0CALDAY part of your budget cube?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Then you cannot put a global filter (char restriction) in the query. As 0CALDAY is not present in the budget cube it returns no data. You need use a dummy KF for getting the date in the selection screen. Choose any one KF from your inventory cube and restrict it with CALDAY using your variable. This way your selection screen still has CALDAY input but without restricting the data. You can write exits to derive the low and high value of your period and use them in the budget RKF.
Hope this helps.
Regards,
Dhrubo
hi,
make a copy query, then step by step remove all the restrictions on the query and see which characteristic is resulting in filtering out the inventory data. And if removal of all restriction also does not bring data, then add the base inventory kf in the copy query and then one by one add all the restriction applied on the RKF for inventory data.
regards,
Arvind.
Hi Swatha,
1)Can you please check once again the assignment of info objects it should be from both data target.
2)check the data in to each data target for same conditions
Regards,
Ganesh Bothe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check your two base cubes have data for reporting symbol?
Any failures of roll up or create index?
please check them.
Even try to run your report thru RSRT - use debug option.
That may give idea, where its stopping to display data from two cubes.
Mean while try to see the data thru t code - LISTCUBE.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
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.