Changing Quick view depending on cell drop down

[kalyan846]

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 dimensions in a excel , depending on that can we pull the Quick report into excel ?
Ex :- cell will be drop down of all dimensions ---> If we select product dimension can it pull product dimension default view ?
so that it will be easy for the users to enter the values

if any one can help me please do it, its urgent

[kalyan846]

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

[Wim Gielis]

Did you test whether the columns can be made dynamic ? Because if/as the elements of the dimension go into the rows, the attributes will go into the columns.

But why would you use PAX if PAW has an editor, built-in ?

[kalyan846]

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

[Wim Gielis]

For example, here you see the PAW editor for dimensions:
https://revelwood.com/ibm-planning-anal ... on-editor/

[lotsaram]

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.

[kalyan846]

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 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

[tomok]

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 out of any of the }ElementAttributes cubes and then change the TM1RPTVIEW formula to pull the first parameter from the results of a drop-down that has all the }ElementAttributes cubes in it. You can then modify the columns to pull the actual attribute elements by numbering the columns, 1 thru whatever, and putting a DIMIX formula in each column to pull all the individual attribute elements. Now, whenever a user selects one the attribute cubes from the drop-down and rebuilds, it will show all the attributes for that dimension. That's it in a nutshell.

[lotsaram]

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

As Tomok has demonstrated, you can explain in few words with little effort how to do this to someone who already knows what they are doing. The explaination above is enough for someone with a bit of experience to come up with a workable solution. But it is a whole lot more effort to explain to someone who is a beginner and has no idea what they are doing.

In fact it would be way more effort to explain and teach it step by step than to simply do it. And you don't honestly expect someone to do it for you, do you?

[kalyan846]

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 out of any of the }ElementAttributes cubes and then change the TM1RPTVIEW formula to pull the first parameter from the results of a drop-down that has all the }ElementAttributes cubes in it. You can then modify the columns to pull the actual attribute elements by numbering the columns, 1 thru whatever, and putting a DIMIX formula in each column to pull all the individual attribute elements. Now, whenever a user selects one the attribute cubes from the drop-down and rebuilds, it will show all the attributes for that dimension. That's it in a nutshell.

'

Hi, really thanks a lot for replying me, need some clarification please,i have created a active form report out of one of the }ElementAttributes cube
and made the changes to TM1RPTVIEW formula to pull the first parameter from the results of a drop-down that has all the }ElementAttributes cubes in it, and now comes the DIMIX formula in each column, please see the screen shot, is that correct,i have altered only for the first column remaining i didn't change yet

[tomok]

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 reference it.

[kalyan846]

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 reference it.

Hi cool, it works i have used DIMNM to fetch the attributes columns screen shot, Thank you so much for helping me
but what about the elements in the cub how will that fetch when i have used DIMNM it is fetching the attribute name but how can we fetch the
element name, can you please let me know

[Wim Gielis]

Please do not skip TM1 101 classes...

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

[kalyan846]

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

[kalyan846]

the dimension is fetching from B2 as you told

[Wim Gielis]

Then it should work, provided that B2 holds a valid dimension name.

What is the formula in B4 and similar cells in the grid ?

[kalyan846]

=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 ?

[tomok]

=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 ?

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.

[Wim Gielis]

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.

[kalyan846]

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 a new dynamic report and i have made the changes
but can you please let me know how to coordinated the =TM1RPTVIEW("KT-FPA:}ElementAttributes_Account:40173141",0,TM1RPTFMTRNG40173141,TM1RPTFMTIDCOL40173141) the "Account" part need to change to C14