TM1 Forum

Thanks for the inputs. 1. Our BI package is DQM package 2. Can you give me more details on the qfs settings? Most of the settings seem to be set by default for DQM. "cross join thereshold" is the only setting that we changed in DQM mode. 3. Our query has the null suppression turned on 4. O...

To your point on tweaking the BI report , we are working with the IBM support guys to help us with queries because they are extremely verbose and not sure what data item in the report query is creating the dynamic expressions on the Tm1 server. As you mentioned, looks like the issue is with the spar...

Thanks Jim and Ramckenzie for your response. Ramackenzie, You are correct. we have the individual segemets and the GL code as seperate dimensions since we could not generate the GL code dynamically for the reports in cognos BI. Also, the cube itself is performing really well. The problem is with how...

We have a cube that has 8 diemsions and one of the dimensions(GL codes) has around 99000 elements. we have cognos BI reports on top of this cube. The reports that are at the GL code detail level are taking a long time to run. Is it a good design to have 99000 element diemsion in a cube? And the runt...