TM1 Forum

Hi, it’s been a while since the last reply in this thread, but maybe a short update will still be useful for some people. I found out that control objects are still ignored by default. However, the wildcard is now supported , so you can explicitly include all control objects in the project definitio...

Hi gtonkin,

That's exactly the point. When I edit the system information cell (by default C3), then PAx is resetting my change each time the sheet gets refreshed.
I'm using PAx 2.0.50. Is this working differently for you?

Best Regards
Tomasz

Hi, Does someone know if there is a way to switch the "model name"/"package" in PAx in an exploration view by connecting it to a named range? If I try to do it like in a dynamic/custom report, then the formula in the system information cell gets overwritten by PAx. I need it to s...

Hi Jorge, You can filter a dimension base on cube values from a combination defined in the MDX statement. http://www.bihints.com/book/export/html/68 -> Section Filter, by values, strings and attributes or http://users.skynet.be/fa436118/wim/tm1_mdxstatements_EN.htm Best Regards Tomasz Brzoza

Hi Wim, I installed PA 2.0 and tested it. Results: When I run my TI Process and the picklist cube doesn’t exist the selection doesn't appear. After the restart the picklist is available. When I execute the process again and add a picklist to the same cube but another element combination the picklist...

Hi Wim,

what is the latest version for you? Planning Analytics 2.0?
I tested in with 10.2.2 FP4 FP1 & 10.2.2 FP6 IF4 and both versions did not shown the picklist after TI execution.

Best Regards
Tomasz

David Usherwood wrote:Did you run File\Refresh Available Servers? That is typically necessary to make new objects visible to Perspectives.

Hi David,

yes I tried this already, but the picklist selection wasn't available after the refresh.

Best Regards
TomaszB

Hi Jorge,

create an Active Form or View and use a MDX to filter the values
Best Regards
TomaszB

Hello everyone, I need to create picklist cube using a TI process, but after executing the code the picklist is not available and an instance restart is required to enable the picklist. If I do the same action manually the picklist is available directly after definition. Is there a way to enable TI ...

Hi All, Many thanks for posting the use case LotsaRam and for the testing from your site Steve. I was able to reproduce it using the FP6 but I do not have the IF1. It would be good it the IF would fix it. I will request it from IBM and post my results later. Cheers! Tomasz Hi all, IBM just released...

Hi All,

Many thanks for posting the use case LotsaRam and for the testing from your site Steve.
I was able to reproduce it using the FP6 but I do not have the IF1.

It would be good it the IF would fix it.
I will request it from IBM and post my results later.

Cheers!
Tomasz

Hi all, I received last the information that after installing 10.2.2 FP6 (even IF2) persistent feeders can delete cube data. http://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1PI70620 After asking IBM when it can really happen, I got the answer that the data that could get lost are thos...

Try using a picklist and put rules on the picklist. I've used this to limit country selections based on regions in the past, Jim. Thanks you very much Jim!!! That is the perfect solution for my. It is working very good. I spend so much time on it and had not this very simple and good solution. :oop...

Hi Everyone, I’m trying to build a simple selection matrix where the possible options should be limited after the first and each selection. This means that if someone selects the action A1, then this option should not be available for further selection in any other dimension element. The attached pi...

Hi Roey,

A very similar thread has been started today http://www.tm1forum.com/viewtopic.php?f=3&t=9056.

Which Excel version are you using with Xcelerator? 2007/2010/2013? 32 or 64bit?

Regards
Tom

What if we have large number of excels where to as well we need to add this parameter in name manager ? Is there a way to add / update name manager for large number excel worksbooks without manual work ? like using a VB script or something ? Thanks Hi, Yes you can change it using VB like almost eve...

Hi Trevor I would really like to use insight as a front end for an application I'm developing and tried the central application suggestion (very simple application, 2 views both from the same cube) but it won't deploy! There's some error about invalid annotation context. CentralAppErr.png Any sugge...

I haven't got the DISTINCT function working appropriately but have you considered INTERSECT between 'Total Europe Memo Items' and 'Total International memo items'? I considered to use the INTERSECT function but it is not always the case that an element from 'Total Europe Memo Items' is in 'Total In...

Robin thank you for the answer. I will definitely avoid the DESCENDANTS and start to use the ALL, RECURSIVE statement. Unfortunately it isn't solving the problem. The duplicates are still there after using the changed MDX expression and the distinct isn’t filtering it out. I have created a sample en...

Hi Everyone, Has someone of you encountered a problem with the distinct TM1's MDX set function? I'm trying to list unique, zero level members from a consolidation. The consolidation contains repeating elements which were copied to 2 subconsolidations. While trying to list all the members using the b...