TM1 Forum

=TM1RPTROW($B$9,"server:Global Orgstructure","","","Code and Name",0,$C$14) i.e. just referencing the MDX formula However nothing changes - still it doesn't update the active form unless I replace the cell reference in the MDX formula with hard-coding. Edit: ...

lotsaram wrote: ↑Fri Aug 23, 2019 12:11 pm Have you looked at this?

clever way - i like ist
hopefully he's using PA

Hi,

i always build the MDX Query in a Excel cell (with reference etc...)
In TM1RPTROW i only refer to the cell.
My TM1RPTRow looks like that:
Maybe that helps
Best regards
orlando

One quick thought: Unfortunately there is no login possible/not possible switch - at least I haven't met one yet. Maybe it could go over the rights. Use TI to read out all user rights and save them to a file or cube. Remove the rights from all users or create a group that is not allowed to do anythi...

Hi orlando, This view is automatic generated from contributor and this is a private view. How this happens, and how can we avoid this issue? And after creating a dynamic view through MDX, will this issue gets solve? Hi! Sorry, I never worked with the contributer and never saw it running anywhere. M...

The view does not open and shows view corrupted, and the name of view shows like this " 1r_15A.Grinding Aid Usage %_c6109cee-c939-482d-95d3-00a17becc8ec_[}tp_tasks}c6109cee-c939-482d-95d3-00a17becc8ec].[N213 - 5001].CAMID(_Holcim_u_9149d87f5f2360489aadadc5f4631706_ ) " . How is the name o...

So one last thing to do, how i could check if TM1 is already connected to a Server? i would play with the TM1User in Excel https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_wrk_tm1user.html if empty - not connected. If not empty - connecte...

and for MDX - i recommend this site

http://www.bihints.com/book/export/html/68

HighKeys wrote: ↑Fri Aug 16, 2019 8:25 am Hello,

thanks for your help!

But could you help me also how i can check if the Ribbon is loaded or not?

Hi,

i would check, if the XLA is loaded.
Somethink like that schould help
http://www.office-loesung.de/ftopic30774_0_0_asc.php

Best regards
orlando

Hi,

i like the PDF Files IBM provides.

https://www-01.ibm.com/support/docview. ... wg27049091

Best regards
orlando

Hi, if i have to connect via VBA (what i try to avoid) i use the VBA API: https://www.bihints.com/tm1_sdk and this sub ###################### Sub con hUser = TM1SystemOpen() AdminHostName = ThisWorkbook.Worksheets("Adr").Range("_adm_1") ServerName = ThisWorkbook.Worksheets("...

Is there any definitive list which details what is and isn't recognised on the tabs? And when processes need to be split up? hi maren, maybe you should read the documentation - this will give you a good overview of what TM1 can do and how it works. https://www.ibm.com/support/knowledgecenter/en/SS9...

lotsaram wrote: ↑Fri May 24, 2019 7:40 am I will also be at the Anwendertag next week. If you are interested in re-ordering (aka "cube optimization") and what it does I recommend you read these posts.
what is cube optimization?
how to find optimal dimension order

hi,
thanks for the links.

See you in Ehningen

You don't need to destroy the cube to re-order. Re-ordering the cube back to the original dimension order can be on the fly without re-creating the cube. Thanks for the tip I wouldn't have thought that TM1 would recognize this. Strange bug. I will talk to them on tuesday - and come back with the an...

Did you re-order the cube dimensions ? There is a bug in PA (can't recall which release) with Rest API that will cause such issues if the cube has a re-ordered dimensions. Even PAx is facing the same problem. Hi, i used an VLookUp in Excel to identify the missing rows. The data doesn't look unusual...

Hi Wim,

thanks for the reply.
The view contains only Level 0, no strings and the cube has no rules.
I will try to make it smaller and investigate.
This will take a while, a lot of meetings and vacation ahead

Best regards,
orlando

Hi there, I have a problem with the RestAPI If I export a view via Ascii Export I get 34960 lines back. If I query the view via the RestAPI, I get 34013 lines back. I call the RestAPI via a Post: https://MyServer.de:8001/api/v1/Cubes('MyCube')/Views('MyView')/tm1.Execute?$expand=Axes($expand=Hierarc...

How do you workout the number of full months between jan 10 2016 to jan 9 2021 . hi, something like that should work. Date1 = jan 10 2016 Date2 = jan 9 2021 1: full month of the first year 12-Month(Date1) = 11 2: month of the full years: (Year(Date2)- (Year(Date1)+1) * 12 = 48 3: Full moth of last ...

Hi davide, i would say, that this is a total normal behavior, beause you're exporting an xlsx file and not an extra file for perspectives. what you could do is: Add perspectives (tm1p.xla) to the add-ins that start with excel. then your user can use the sheet (after login to tm1, of course). best re...

The exact scenario is like, in workbook1 i have Year field which has subnm function and it opens all the years(2017,2018,2019) in the dimension. Now if i select a year 2019 in this year field. If i go to workbook2 now i want 2019 value to load automatically in the year field of workbook2. And in wo...