TM1 Forum

Unless you are needing the labels to vary because of reporting requirements by the users, Orlando's solution should do it. However, if you really do need the labels to change, another solution is to use an MDX subset on the Month dimension. Add elements to your month dimension for each year/month c...

Dear professionals, Is there a way in Rules I can do to push data into another cube from this cube.

Ex: if I'm in X cube I want to push data to Y cube using Rules.
This will solve my problem.

Thanks a lot,
Best Regards.

Dear all, Appreciated for your aid.

Please this what I ask for.

Unless you are needing the labels to vary because of reporting requirements by the users, Orlando's solution should do it. However, if you really do need the labels to change, another solution is to use an MDX subset on the Month dimension. Add elements to your month dimension for each year/month c...

If Year is a title dimension, how can you show 2 years in your columns ? The problem is: My customer wants to see the following:- in the view where year = 2017 YTD of 2016 and FYR of 2016 and Q1 of 2017, ... , Q4 of 2017 So I want to Merge the year 2016 with YTD and FYR and 2017 with Quarters. That...

Do you have year-specific elements in the Months dimension, and again years in the Year dimension ? Hello Wim Gielis, Happy to see you. Month Dimension contains elements (Jan to Dec, YTD and FYR) Year Dimension contains elements (2017, 2018 and 2019) I want to do this for displaying only, because m...

Hi Hector, why do you need month elements like YTD-2107, Q1-2017, Q1-2018 if you have a separate year dimension? The elements YTD, Q1,Q2,Q3 etc... should be enough. Just use your month dimension in the columns. Then you will see the figures of the selected year. Regards, orlando Hello Orlando, Sorr...

Hello Professionals, Happy to see you. Please I have a cube called production, its Measure dimension in row, Month dimension in its column and has a year as a filter. Month Dim has many elements but we want to use the following elements only: YTD, FRY, Q1, Q2, Q3, Q4 Year Dim has: 2017, 2018, ... I ...

Wim Gielis wrote: ↑Mon Mar 05, 2018 8:41 pm

Hector2005 wrote: ↑Mon Mar 05, 2018 1:10 pmSorry Sir, I know that this makes you nervous.

Correct.

This is a matter of copy/paste, I already directed you to the solution on a web page with the expression that you need to use.

any way I want to thank you sir, you are right, I got it.

1- Why when I drill down in Project_levels, Architect changes its subset to another subset ? In the subset editor, when you click on the plus or minus sign to drill up or down, TM1 accesses the entire dimension to determine what the resulting set should be after the drill down or collapse, not just...

Then the first part of the MDX needs to be changed. Use DrillDownLevel, an example is listed on my website on that page. Thanks Sir, But It seems that I want to read all instructions to solve that, If you can help me speed up this by solving it. I will be appreciated. Sorry Sir, I know that this ma...

Ohhhh my god, It's worked successfully. Actually I don't find any words present my feelings. Really Appreciated Sir .. I have three questions: 1- Why when I drill down in Project_levels, Architect changes its subset to another subset ? If there is a solution I will be more more grateful. 2- Could y...

The code attribute should only be filled in at level 0. Attached a picture. Ohhhh my god, It's worked successfully. Actually I don't find any words present my feelings. Really Appreciated Sir .. I have three questions: 1- Why when I drill down in Project_levels, Architect changes its subset to anot...

Q1: use Excel references and IF formulas to come up with the right elements. Do you put these months/years in the columns of a websheet ? Or where exactly do you use those 2 subsets ? Q2: I would use a SUBNM to aks a period/year combination by the user. Then make all your subsets once manually and ...

Dear my friends, Really appreciated from your aid. Sure I have a question :D :D , I use Planning Analytics 2.0 on a Windows OS. Recently I have a problem Suppose I have dimension contains categories just (Consolidated elements), These consolidated elements will contains childs, These childs will be ...

Creating a subset happens in 1 dimension. A subset (usually) has little knowledge of what happens in the other subsets of cube dimensions. It depends on the client used. In Excel and TM1 Web, you can use Excel cell references to come up with logic to return the required elements. In the cubeviewer ...

Hello friends, hope everyone is good enough. I have a question about subsets. I built a model using IBM Cognos Planning Analytics TM1 (Performance modeler), in this model I have two dimensions for time : Month Dimension and Year Dimension Month -Q1 Jan Feb Mar +Q2 +Q3 +Q4 Year: 2017 2018 2019 My Pro...

Finally I made it, I want to thank you very much for your concern(Iotsaram , Elessar), really you mentioned a critical point. Solution: I just copied the following files TM1p.ini and TM1p8.lic from : 'C:\Program Files\ibm\cognos\tm1_64\bin64\TM1p.ini' 'C:\Program Files\ibm\cognos\tm1_64\bin64\TM1p8....

Elessar wrote: ↑Tue Feb 06, 2018 12:02 pm Hello! You do not have admin rights on the server. Check }clientgroups cube

You are right, When I browse it I just see one cell has Admin value.
I cannot do anything else.

Thanks a lot,
Best Regards,
Hector.

Thanks for your answer I think It's a critical one, you are right I see only 'Change Password' So, If this file is missing What is the solution?

Thanks a lot,
Best Regards,
Hector.