I have a scenario like i have one Infocube which will have cost center and Cost element in it and other as well like controlling area, company code, Fiscal Year Month, Profit center, person responsible. amount1
I have another infocube which willhave
Purchase order , Purchase order item, Cost center , cost element, Profit center, company code, controlling area. open amount
I want to report
Cost element which will be in rows and key figure will be Amount1 Amount
and others in filter area.
will i get everything in one row when the cost element and cost center are same in both the cubes.
And what happens when one cube as cost center and other doesnt have cost center or cost element for the purchase order will that value goes to not assigned.
Thanks and regards
Here as you gave the example, it will always show # below Amount1 as no data in other cube and it will show # for Amount for the onther cube. You will get one record if you will use either onn these KF.