Search found 8 matches

by LGEIS
Thu Nov 25, 2021 9:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?
Replies: 10
Views: 1726

Re: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?

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!
by LGEIS
Mon Nov 22, 2021 8:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?
Replies: 10
Views: 1726

Re: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?

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...
by LGEIS
Wed Nov 17, 2021 3:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?
Replies: 10
Views: 1726

Re: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?

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...
by LGEIS
Wed Nov 17, 2021 1:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?
Replies: 10
Views: 1726

How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?

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...
by LGEIS
Tue Nov 16, 2021 10:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to iterate over odbc input columns?
Replies: 4
Views: 1207

Re: How to iterate over odbc input columns?

Thanks! This might come in handy, when the actual model gets integrated into the production environment
by LGEIS
Tue Nov 16, 2021 9:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to iterate over odbc input columns?
Replies: 4
Views: 1207

Re: How to iterate over odbc input columns?

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
by LGEIS
Tue Nov 16, 2021 9:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to iterate over odbc input columns?
Replies: 4
Views: 1207

How to iterate over odbc input columns?

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...