TM1 Forum

Hi Maren

The architect option did not work however, your suggestion of using SubsetAliasSet was greatly appreciated.

Thank you!

Francois

Hi Maren This MDX is currently saved as a dynamic subset. I've tried switching on the Alias PAW set editor but you cannot commit the change to the current set without overwriting the MDX set. Below is the view of the set editor in PAW. Screenshot 2023-06-26 at 12.49.04.png I might have it wrong, but...

Hi Maren Thanks. This is an option but we have many entities each with its own maintainable set. It defeats the purpose where you know have to create multiple static sets, maintain them without creating locking, and then create another MDX set to reference the static sets to make your books and repo...

Hi there, I'm struggling to find a way to display an alias for the following MDX. The goal of the MDX is to retrieve accounts which is specific to an entity from a TB load and only 'Active' accounts. FILTER(TM1FILTERBYLEVEL(DESCENDANTS([Account].[All Account]) , 0) , [lkp.Account Setup].(STRTOMEMBER...

Not sure that I would use HierarchyDeleteAllElements, would rather unwind the hierarchy like you would a rollup. Hi gtonkin, yes you are right but in my case, all elements will be mapped in the hierarchy in every run. Those with no attributes will default to the 'Other' consolidator. As data is sto...

Hi, More and more clients are requesting real-time process information when they run/execute a job from a UI either through TM1Web or PAW. Most of our deployments come with a 'TI.Monitoring' cube which tracks processing time and other stats. This issue is that this information is not real-time throu...

For all of you who are interested, createhierarchybyattribute should be used with care and demo purposes. This is limited to a more once-off use case rather than using it on a reporting hierarchy that is ever growing in size. In a production environment, creating and maintaining a virtual hierarchy,...

Hello, Could you reproduce the behavior on any dimension (even new, small, dimensions) that have a suitable attribute ? Is it done in TI or manually ? If TI, what's the function call you use ? Wim, I did that straight after I posted the question. To my surprise, it did work through a TI on a small ...

Hi all We recently upgraded a local PA installation to TM1 2.0.97.6. We hoped to use the hierarchy create by attribute function via TI or through PAW, but each time it's created the server crash. This was supposed to be fixed in 2.0.9.1 LC. https://www.ibm.com/support/pages/system/files/inline-files...