Print Page - Filter on Transformer Model

Title: Filter on Transformer Model
Post by: hrk551 on 19 Apr 2010 08:52:07 AM

I have a report running on PowerCube, It is taking long time to run the report, so I want to reduce the data in cube and I want to put a filter on cube Can I do that in Transformer model, give your suggestions on this and If possible give your thoughts on Cube optimization to run the report fast.

Thanks!

Title: Re: Filter on Transformer Model
Post by: MFGF on 19 Apr 2010 11:43:22 AM

Hi,

More information is needed - sorry. How is the report written against the cube - ie does it use detail/summary query filters? Which studio/client has been used to write the report? How many queries?

MF.

Title: Re: Filter on Transformer Model
Post by: hrk551 on 19 Apr 2010 12:16:19 PM

Used Detail fliters in Report Studio and used 4 queries

Title: Re: Filter on Transformer Model
Post by: MFGF on 20 Apr 2010 05:19:39 AM

Hi,

Sounds to me like you are using relational reporting techniques, which will often give poor performance against a cube.

Can you outline what the report needs to do - if so we may be able to suggest the appropriate dimensional expressions to use, and be able to do it all in one query.

Regards,

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: hrk551 on 19 Apr 2010 08:52:07 AM