How to dynamically use .IQD

[nayitian]

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

[COGNOiSe administrator]

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

[COGNOiSe administrator]

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