TM1 Forum

Hi, I could be mistaken, but wouldn't you also have to reference the context dimensions? Without knowing the exact order of the dimensions, shouldn't the resulting rule be something like: SKIPCHECK; [] = N: DB ('600_Sum_Details', !600_Sum, 'Total Organization', 'Total Line Item', !months, 'Amount');...

Hi Sana, A lot of times, if there is no record of the error in the logs it means that the user did not have permission to run the process. A "process failed" error message appears in the screen, but nothing appears in the logs because the process doesn't even get as far as running (and fai...

Hi Shane,

Your vVar should not have quotes around it. You are setting vVar equal to "CellGetN(Value)", which is a string. At the bottom, when you are trying to switch that from a number to a string, it is getting confused because it is already a string.

Jeff

Hi,

We have had success by setting the User Interface options to 'Optimize for Compatibility' (under Excel Options --> General, it should be right at the top). I believe you will have to restart your Excel for the fix to take effect.

Hope this helps.
Jeff

According to the new Reference Guide, it looks like ELISANC is the hierarchy-less version. If you want to use one and specify a hierarchy, it seems the new rule is "ElementIsAncestor".