Skip to Content
Former Member
Nov 08, 2005 at 03:55 AM

Accessing Formula/Selection Cross Query(Same InfoCube)


Good Day matez',

I have

Query A - Group Operating Cost

Here, in my

Columns : 1 Structure named Period Structure

Rows : 1 Structure named Operating Costs

The Structure 'Operating Costs' contains various

FORMULA's like 'Operating Cost before Depreciation',

'Total Cost'

SELECTION's like 'Manpower Costs', 'IT Maintainance'

NOW, I need these

FORMULA's like 'Operating Cost before Depreciation',

'Total Cost'

to be available in <b><u>another</u> Query</b> for the <u>SAME</u> InfoCube

At this moment, I can only see the global Structure's which I have created in various Queries for the SAME InfoCube, but I specifically need is the FORMULA's that I created in those STRUCTURE's itself.

P/S: As we understand my new Query will have to utilize the Period Structure in ROW. Hence, I`m only left with another STRUCTURE to build this combinations of FORMULA's from another query