TM1 Forum

Voted

I know that référentiel is used to set up dimensions. Actually, my colleagues in Paris have such a module, called référentiel, to quickly create dimensions. Similar to xdi but then in TM1 Web and a TI process with action button to create / update a chosen dimension. It's more of a template in fact, ...

pikolikoli wrote: ↑

Wed Jan 20, 2021 11:15 am

Thank you So much Alan. This is very helpfull

The naming 'Referentiel' is what is used in some companies. I think it is a key word used by clients so it became a norme I guess.

Thank you

Could it be that you're a French speaking person natively ?

Isn't this just creating an MDX (in Excel) that drives the rows of the active form ?
Whereby the MDX filters out the desired elements based on an attribute flag.

We both think Steve’s reply is already what the OP needs

We have seen performance of MDX views vs. standard/classic views to be poor. Looking at your MDX code, it does not appear you are using alternate hierarchies, so building a classic view should not be a problem. I would suggest trying that. I believe the performance problem is directly related to wh...

Use 0 everywhere if you want to insert elements in the order in which they are listed in the code.

Are you really sure that your process enters the Metadata and Data tabs ? Did you check the view settings ?

Maybe the documentation is referring to the rule that says if you have WRITE to the cube, WRITE to the dimension, but READ to the element then you have READ. You have to have WRITE all the way down to have WRITE. That would be new to me. READ access to a dimension is sufficient for WRITE access to ...

Hello

You need elementtype: https://www.ibm.com/support/knowledgece ... ttype.html

I am having issues with that Russian terrorist called Kaspersky but it's the company choice

I haven't done that yet. Yes, experimenting with a Perspectives websheet and the HYPERLINK function into it can maybe lead to a solution, use the TM1User function in Excel as well as part of the hyperlink to jump to.

I would give each user his or her own folder. All subfolders of 1 root folder. If you do this in a consistent way (through naming and/or attributes on the }Clients dimension) then the DataSourceNameForServer function in the Prolog tab can easily satisfy which subfolder it is, and load the data. Norm...

cdhodge2002 wrote: ↑

Wed Dec 09, 2020 4:55 pm

Guessing that means no one has put data into a PAX report using data from Planning Analytics and Cognos Analytics at the same time.

I didn't, that's for sure.

The fun becomes even bigger if we also take into account
- the CurrentArray range. It is associated with good old array formulas (Ctrl-Shift-Enter to confirm).
- the spill range. It is associated with the new dynamic array formulas (which are awesome by the way)

Joy joy...

Hi You didn't show the SUBNM Does it by any chance identify the element in something in double quotes rather than an index number? If the value for the element is given in quotes, then it will always show that value whether it is in the subset or not. It you give an index it will show the element a...

luizg2019 wrote: ↑

Wed Nov 25, 2020 2:49 pm

Should I make a topic about this on the "Useful code, tips and tricks" section?

Sure, please do so

Hi Wim Gielis, Thank you for your reply. I used the similar logic. Your code and my code produces distinct list of elements. But I want to delete all the elements that are appearing more than once. If you look at the example I provided in my original post, elements "Banana" and "Orange" appear twic...

Indeed, good catch !

I forgot, even when I do this all the time manually in the Subset Editor !