Slower after converting into static values?

[macsir]

Hi, I have a complex view which takes around 6 minutes to build using rule. The base data is referred from another cube using DB function. To speed up, I convert this part of base data into static values using TI procee and disable the DB function. The result is right but building that view even takes longer time which is around 14 minutes now. I can't understand...

[Steve Rowe]

Can I check you have restarted after making the change, cleared away and .FEEDER files?
I can't think of anything really obvious, maybe you need to fiddle with the dimension order as making values static might have changed the sparcity in some way, though I'm not 100% sure that would make sense..!

[macsir]

Can I check you have restarted after making the change, cleared away and .FEEDER files?
I can't think of anything really obvious, maybe you need to fiddle with the dimension order as making values static might have changed the sparcity in some way, though I'm not 100% sure that would make sense..!

Thanks, steve. Yes, after rebooting. It is faster although not fast eoungh as i expected.