on 01-09-2012 10:34 AM
When navigating in the contents of technical content InfoCube 0TCT_C01 I would like to check the base data from view RSDDSTAT_OLAP. Is it possible to build a report-to-report-interface (RRI) which uses the Step ID from 0TCT_C01 and displays the related contents of view RSDDSTAT_OLAP?
I am new to reporting, and I already fail to build a BW query on RSDDSTAT_OLAP because the view is not an InfoProvider.
Hi,
The technical content InfoCube 0TCT_C01 gets feeded by datasource 0TCT_DS01. This datasource is based on a Function Module RSTC_BIRS_OLAP_AGGREGATED_DATA which basically access RSDDSTAT_OLAP table.
You can check the contents of this table in SE16 t-code. You have to create a Query on your Cube, because this cube gets data from the mentioned table. I think RRi is not required.
Regards,
Suman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Suman,
thanks for your answer! I already check the contents of RSDDSTAT_OLAP via sqlplus (which I personally find more practical than SE16 or a function module).
However, I deem it useful to have a drill-through via RRI from the 0TCT_C01 data to view RSDDSTAT_OLAP (or one of the RSDDSTAT* tables). If such a feature is not possible or would be very difficult to implement, then I would be glad to know.
Regards,
Mark
Hi,
We can jump from a Query to several report types. You can see in RSBBS t-code. Since you want to jump to a table from your query, you create simple Infoset Query based on RSDDSTAT* tables.
After creation of Infoset Query, you can create a jump selection in RSBBS t-code.
http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/607e63d5-b56f-2c10-718f-8e33a08baa89
Regards,
Suman
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.