Question:
Dear all,
I want to create a report from a transactional cube. Can I? I tried, but there's always 'no data applicable'. How can I do this?
Thank's for your help.
Answer:
You need to add the "Most Recent Data" variable as a filter for request ID in your queries. This way you'll be able to report on open requests.
Answer:
Guille, thank you.
But how exactly do we do this? There's no 'Most Recent Data' variable in the query for me to filter. Do we have to set something in the workbench?Or is it supposed to be in the query automatically?
Please help. Thank you....
Answer:
guest,
it is not a variable, but rather a characteritsic u find in Infopackage dimension. check that out.
Answer:
To be specific 0REQUID technical characteristic
For reporting u just need to pull these in Filter and it should work.
Tips-
3 Variables do exist for these charecteristic as listed below
0S_RQMRC:
You should use this variable if you want a query to also return data that was yet not rolled up into the aggregates. However, only requests up to the first request with an incorrect status are displayed, transactional InfoCubes are therefore read in full.
0S_RQTRA:
Unlike the 0S_RQMRC variable, this only affects transactional InfoCubes. As during normal reading, only the data that is also in the aggregates is read from the other InfoCubes. You can use the variable in queries on a MulitProvider that consists of a transactional InfoCube for planned data and a second InfoCube for the actual data. In this case, the planned dates entered are immediately visible, but the actual data only becomes visible after the usual release procedure.
0S_RQALL:
This variable affects all InfoCubes. If a query contains this variable, all of the data in this InfoCube is read, regardless of whether or not it belongs to a request with an incorrect status.
Hope it helps
_________________
Chetan
@ CP...
Answer:
Thanks for your help, guys...
I pull 0REQUID in Filter....but still the data won't show up.
Is there anything that I miss? Probably there's configurations I need to fix in the cube itself?
Answer:
Thanks for your help, guys...
I pull 0REQUID in Filter....but still the data won't show up.
Is there anything that I miss? Probably there's configurations I need to fix in the cube itself?
I would have to switch transactional cube first for the data to come out.
Please help....
Answer:
Should have worked
Try variables
Most Current Data - 0S_RQMRC variable pulling in the filter
OR
0LSTRQID - Last Request Loaded
along with that charecteristic.
Hope it Helps
_________________
Chetan
@ CP...
Answer:
Chetan,
Thank you.
There're no 0S_RQMRC & 0LSTRQID in the query analyzer. Only 0REQUID exsists. Any settings need to be done?
Btw, I'm using SEM 3.2 on top of BW SEM 3.1. Would this have an impact?
Answer:
0REQUID is the name of the characteristic, you will find the variables chetan is referring to if you navigate through the nodes "hanging" from the 0REQUID characteristic in the query builder.
Hope that helps, let us know.
Answer:
Dear all,
Thank's a lot for your help, guys.....
It works now....I had to install the variables you were talking about from business content....
Thanks a lot.....=))
Answer:
Hi Guest
which variables u installed?did u install the same variable which
CHETAN mentioned??
plz advice