cancel
Showing results for 
Search instead for 
Did you mean: 

joining queries

Former Member
0 Kudos

Hello,

I made a query for an InfoCube, containing Delivery #. I have an ODS with detailed delivery information. How cam I make it possible that when I click on the delivery # in the IC query, I see the detailed information from the ODS?

Thanks in advance!

Savita

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

by jump-target.

create a query on the ODS (if not already available).

go into TRC RSBBS -> create a jump targe for the CUBE-QUERY.

Assign the ODS-Query and in the Assignment -Details set everthin except Delivery-Number to "deleted".

int the cube-query go to the relevant line, kontext-menu, GOTO-> ODS-Query.

hth

cheers

sven

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Savita,

You can use the report to report interface option. Here you can click on the value in the report based on the cube which is passed as a parameter to the detailed report based on ODS which get called internally.

check the following for the report to report interface details:

http://help.sap.com/saphelp_erp2004/helpdata/en/84/2b813b731fd60ee10000000a114084/frameset.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/6eb89190-0201-0010-89bf-ad4...

HOpe it helps...

thanks,