TM1 Forum

No, but the elements are not changing dynamically when i select the dimension, i tried it

concatenating if this is done i will be good to go, last step i think so

Maybe because this appears to be a custom report and not a dynamic report. If it were a dynamic report the formula in A1 would be TM1RPTVIEW and not VIEW. Indeed, good catch tomok. If the OP just starts with a dynamic report on the relevant cube, it would have been much easier. Ok now i have taken ...

=DBRW($A$1,$A4,B$3)
Everything is working fine, when i am changing the dimension it is fetching all the corresponding attributes from that dimension
But .... the elements are constant it is not changing, is there any function like DIMNM() to fetch elements from that dimension ?

the dimension is fetching from B2 as you told

Wim Gielis wrote: ↑Thu Jun 18, 2020 7:34 am Please do not skip TM1 101 classes...

Cell A1 seems to have a servername, then }ElementAttributes, then nothing ? No dimension name at all ?

My server is only : KT-FPA

Your DIMIX isn't going to work because you have a circular reference. The second parameter in that formula is an index number, 1 thru whatever. You can modify the formula to be DIMIX(Server:Dim, 1)....DIMIX(Server:Dim, 2)...DIMIX)Server:Dim, x) or you can add the index number in a cell above and re...

Yes i understood, as i told i am very new to PAx and PAW, can you please tell roughly how to achieve it in the easy way, if you have time please Easy is a relative term. If you are new to Planning Analytics then it isn't going to be easy for you. Basically, you need to create an active form report ...

Why do you specify quick report? There are a number of ways you could achieve this. It would be very easy for example with an active form (now called dynamic custom report in PAfE). Or it could be done very simply with a native drill-through. Plus other ways to do it. Yes i understood, as i told i ...

as i am new to PAw and PAx i am not sure which one will suit
can you please let me know how it works please

depending on the selections of my excel drop down, can i open that view on the sheet ?

Hi All, actually i am trying to give users access to edit the dimension attributes using PAx Quick report so, I have nearly 100 dimensions, so we have control cube }element attributes_ dimension name,so the dimension name will be changing at the end so i want to create a drop down list like all the ...

Yes, when i enter the server name, it pops up for windows securities like user name and password i have those with me but how can i implement it for example :- when i am taking that server name and entering into file explorer it pops up for windows securities user name and password can you please le...

ascheevel wrote: ↑Thu May 21, 2020 7:00 pm try replacing "\\data\s\" with "s:\"

No luck, its not working

Hi all, i have a Ti process, in that we are taking data source as .Csv file Recently we have moved into cloud and we have migrated everything into cloud and in here the file in shared location which has user name and password when i am trying to browse the file what i need to keep in The processing ...

Hi, please dont mind if it a silly Question,
In a dimension i have a dynamic subset, which i want to transfer same structure into another dimension
but that subset is having rollups.
i want the same structure into dimension,via ti process

Can any one help me please........

i think ctrl+A doesn't work
click on first subset holding on shift click on the last subset
now all the subset will be selected

Hi, In Architect, when you login to the instance you will be seeing all the cubes and dimensions click on the dimension which you want subsets for and then click on displayed properties window now on your right hand side you will be seeing all the subsets just click on the first one and Ctrl+A will ...