TM1 Forum

Hey together, actual having an issue with my rule / porportional data spread. My example cube is simple, just 2D with 3 measures and a time-dimension with 12 month and a year element. Screenshot.png My rule: ['REQ'] = C: (['UMS-RED-Betrag-vK'] - ['UMS-RED-Betrag-ez']) \ ['UMS-RED-Betrag-vK']; ['UMS-...

Hi,

happy new year and sorry for the late reply.

Open the Excel file and check for hidden tabs that start with "Picklist***" in the name. You should delete these.

There are no hidden Tabs.

Any other suggentions?

Hi togehter, I have a strange issue on one of my perspective reports in Excel. In some situations (scrolling / clicking in a Cell) TM1 is starting to calculate something even though the automatic Excel calculations are switched off. The OPS Console shows in this moments "CubeCellPickListGet&quo...

Hi again, so this seems to be the important part here: The number of threads you have depends on the number of cores in your CPU. Each CPU core can have two threads. So a processor with two cores will have four threads. A processor with eight cores will have 16 threads. -> My max MTQ limit is 32, be...

Hi lotsaram,

thanks for your reply. Yes, I know the possibilities how to config the MTQ parameter. My question is more about the specs for the Intel(R) Xeon(R) CPU I posted. I'm not sure about the definition what MTQ can use here as parameter. The 16 cores or the 32 logical processors?

Thanks

Hi together, I've a short question about how to figure out the max possible MTQ value for the TM1s.cfg. The servers hardware is the following: Prozessor Intel(R) Xeon(R) CPU E5-2667 v2 @ 3.30GHz, 3300 MHz, 8 Kern(e), 16 logische(r) Prozessor(en) Prozessor Intel(R) Xeon(R) CPU E5-2667 v2 @ 3.30GHz, 3...

Hi, Hi Markus, thanks for your reply. Yes, my "solution" is a mix of both, consolidatedmax & consolidate children. Definitely very ugly, but it seems to work. It's going something like this: IF(DTYPE( 'WS_POS', !WS_POS) @= 'C' & DTYPE('WS_Marke', !WS_Marke) @= 'N' & DTYPE('WS_W...

Hi Markus, thanks for your reply. Yes, my "solution" is a mix of both, consolidatedmax & consolidate children. Definitely very ugly, but it seems to work. It's going something like this: IF(DTYPE( 'WS_POS', !WS_POS) @= 'C' & DTYPE('WS_Marke', !WS_Marke) @= 'N' & DTYPE('WS_Waren...

Hi ascheevel, thanks for your reply! I've already tested some workarounds, but all of them are getting nasty in some ways. I guess your idea will go in the same direction. In total I have to handel 12 Dimensions with that requirement and of course there are some exceptions, where the rule should not...

No one? No ideas or hints?

Hi all, i've got a problem with using ConsolidatedMax in a Rule. Let's say my Cube is 3d with the Dimensions WS_POS, WS_Zeit and WS_Kennzahl and whenever I look at a C-Element in my WS_POS Dimension, I want to see the Max value. My rule is like: ['WE-EB-Option'] = IF(DTYPE( 'WS_POS', !WS_POS) @= 'C'...

Hi Wim, the Cube isn't really just 2D, that was just for the example. So I really have to use feeders. Yes, your second suggestion ist the way I wanted to prevent in some cases :) I really like your third point, because I dindn't know that by feeding a consolidation the children automatically gets t...

Hi,

the value there can be a general input parameter and then should be passed to the other elements. I know, there can be other possibilities, but this way is given for me.

Thanks for the advice with dimnm & dimix.

Hi together, I've a problem with feeding cells and need help to find the correct feeder. Example: My Cube has 2 Dimensions, Measures und WS_Time. The Time Dimension (WS_Time) has 3 n-elements: 1. 20200100 2. 20200200 3. Sum 2020 and the rule is like: ['measure x'] = IF( SUBST( DIMNM( 'WS_Zeit', DIMI...

Hi Paul,

thank you very much for your response!

Unfortunately TM1 Web is no option because of performance issues.
Guess I will try to handle it with the VBA approach.

Regards
TM1NB

Hi Tomok, sorry for my bad description/english. My idea was about creating a new column without any formulas (so there is nothing that could be deleted by mistake) with the intention to let them put their plan values in those new cells... But this is not possible because the value of the first cell ...

Thanks for the quick response. Yes, the report is already stored in the applications folder and can always be used as master. Nevertheless the requirement is unfortunatly like "there must be a possibility to always have the correct formula" in the backround without "repopen" the ...

Hi,

I'am looking for a simple way to protect DBRW formula in perspectives. The cells must still be wirteable, so that Users can type in their plan values without the risk of deleting the DBRW formula in it.

Thanks
TM1NB