Reporting Data Issue

[xinyu]

Hi,
I have a cube A contain 2 dims, opp_no and measures, in measure dim, there are several string element presents the attrbute for opp_no, the default view looks like below
sector(S) LOB(S) QTR(s) Industry(s) data1(n) data2(n)
255u-a DIS AMS 4 BANK 10 15
255u-b IND SI 3 TEL 20 25
................

then what I want to do now is to have a cube B, to switch SECTOR, LOB, QTR and INDUSTRY into dimension, and sector is parent of opp_no. the layout looks like
LOB QTR INDUSTRY
Data1 Data 2
DIS
255u-a xxxx xxx
IND
255u-b xxxx xxx

Anyone have the same experience, how can I use rule to get data from Cube A to Cube B, what I want is a automatic way that data in cube A and B are in the same page, any idea? thanks a lot

[Steve Rowe]

Hi Xinyu,

I think that the only way you are going to achieve this is to process Cube A into Cube B using a TI process.

Cube A is still really a table of relational data even if it is already in TM1, to turn this into a OLAP data set you'll need to process the data with a Turbo Integrator (TI) process. I don't think you can achieve what you want with rules.
HTH

[xinyu]

Hi Xinyu,

I think that the only way you are going to achieve this is to process Cube A into Cube B using a TI process.

Cube A is still really a table of relational data even if it is already in TM1, to turn this into a OLAP data set you'll need to process the data with a Turbo Integrator (TI) process. I don't think you can achieve what you want with rules.
HTH

Thanks Steve
I realized that it can not be done with Rule, since it is totally 2 format. could u please talk more if I use TI, I tried TI this pm, problems is that, I can not use the same view (relational) as a data source in TI, can not map string element into my cube B. Also I think to prepare data out of TM1 then import, but there is a case that, user will use cube A as a input, they will add Opp_NO like 255U-xx themselves, then report based on cube A. so, stopped here...