Print Page - How to dynamically use .IQD

Title: How to dynamically use .IQD
Post by: nayitian on 02 Apr 2007 01:14:13 PM

Hello All,

I am looking forward to your solution to help me out with this situation.
I have a cube exceeding 2GB already, I am thinking of spliting it into cubes by year and just making the past - year cubes disabled, so every time, only the cube pertaining to current year will be run periodically.
But how can I dynamically modify the .IQD fact table, other than hard coding, to filter date to narrow down to the data of current year?

Thanks in advance.

Jac

Title: Re: How to dynamically use .IQD
Post by: COGNOiSe administrator on 02 Apr 2007 02:04:50 PM

Put a filter in based on current date or current system processing date.

Title: Re: How to dynamically use .IQD
Post by: COGNOiSe administrator on 02 Apr 2007 02:05:40 PM

By the way, there is nothing wrong with the cube being over 2GB. Just use MultiFileCubeThreshold to split it into multiple fles.

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: nayitian on 02 Apr 2007 01:14:13 PM