Allocated Memory exceeded

[#1]

Hi,

I have developed a model and I'm trying to design a chart but I can't show it because of the amount of memory it uses.

It's a chart with a complex formula and a composed dimension, I'm sure that my problem comes because of this fact but I want to know if there is any way to solve it without changing the formula.

I've tried increasing the memory to calculated formulas but it doesn't work,

Any idea?

Thanks,

David

[#2]

As you said " the amount of memory it uses".

If your data is big enough and you are writing a complex expression on this large volume of data this will create problem.

Go for set analysis.

Try to make this composite dimension in script.

Write this complex expression in script if possible.

Finally if your modelling is star schema then there are still some hope. LOL

Reg,

Shubhu

[#3]

Thanks Shubhu,

That's the kind of answer I was trying to avoid xDDD,

The formula has aggregations and the model is a bit messy, (Of course I will reduce the data if there is no other solution but i'm running out of time)

I've tried increasing the memory to calculated formulas but is not enought I don't know if there is another option...

Thanks!!

David