Print Page - Adding a relational table to a cube

Title: Adding a relational table to a cube
Post by: UseCog on 25 Sep 2009 05:26:08 AM

Hi,

I have a powercube and now I am having a requirement to add a relational table to the same cube. Basically I dont want this table to function as a dimension of the cube( even this will increase the size).

can anyone help me to achieve this

Thanks

Title: Re: Adding a relational table to a cube
Post by: twlarsen on 25 Sep 2009 10:07:02 AM

If you don't want to use information from the table as a dimension...then what will you be using this table for?

Title: Re: Adding a relational table to a cube
Post by: UseCog on 28 Sep 2009 02:37:12 AM

thanks for your reply,

I want to use this as a burst table.. even i m not sure whether it work or not... wanna do a POC

Title: Re: Adding a relational table to a cube
Post by: redmist on 28 Sep 2009 10:49:50 AM

In FM add the burst table as a new Query subject....include it in the same package and you are all set.
In report studio you can define the relationship and set burst options

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: UseCog on 25 Sep 2009 05:26:08 AM