TM1 Forum

I just found a duplicate: https://www.tm1forum.com/viewtopic.php?t=9239 The outline ist, that I cannot write values from a DBRW inside an Excel formula. Taking this into consideration, I had to do some workaround stuff. My solution is quite simple: Col1: takes the clean DBRW formula Col2: is the ref...

I have got an Excel (I am using PAX/PAfE) cell with a DBRW formula encapsulated inside an IF statement and I want to write back data to a target cube from this cell, just by typing it into the cell manually. When I am using the blank DBRW (=DBRW(...)) formula it works finde, but inside the IF statem...

clearing the cache actually did the trick. I now switched to automatically clearing it when saving the sheet. Both solutions are working just fine know. Thanks a lot!

I am not exactly sure about what you mean

Hi, thanks for your proposed solution. However, as I tired to make it work via List, I encountered some issues again. After I did drag and drop the mdx subset into the list object, it worked fine for the first moment. After I changed the size of the mdx subset, containing 2 elements instead of three...

Hi and thanks for answering! Here is what I did so far: 1. disabled auto refresh 2. Created named range with TM1ELLIST formula as reference (the formula is only working, when I am using the name of the MDX (mdx_Reportarten) and not when I am pasting the whole formula from the subset editor into Exce...

Hi all, for one of my costumers I am starting to use TM1 with Planning Analytics for Excel. As I need a pre-filtered drop-down menu to select a value, that gets than written by TI into a parameter cube. To reach my goal, I was hoping to create a dynamic array in a hidden sheet, that serves as the in...

Thanks! This might come in handy, when the actual model gets integrated into the production environment

Hi Maren,

thanks a lot for the quick help! The EXPAND function does the trick! In my example varDIM would equal EXPAND( '%v' | elemDIM | '%' );

Regards

As I want to fill a cube with as less code as possible, I was considering looping over the sql server input. In my example a value gets written, if several conditions are met. This works fine, unless I want to put it all in a loop. I may use a flat dimension to represent the input variables, but thi...