Page 1 of 2
Changing Quick view depending on cell drop down
Posted: Mon Jun 15, 2020 2:58 pm
by 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
Re: Changing Quick view depending on cell drop down
Posted: Mon Jun 15, 2020 4:15 pm
by kalyan846
depending on the selections of my excel drop down, can i open that view on the sheet ?
Re: Changing Quick view depending on cell drop down
Posted: Mon Jun 15, 2020 4:36 pm
by 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 ?
Re: Changing Quick view depending on cell drop down
Posted: Mon Jun 15, 2020 4:46 pm
by 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
Re: Changing Quick view depending on cell drop down
Posted: Mon Jun 15, 2020 5:01 pm
by Wim Gielis
For example, here you see the PAW editor for dimensions:
https://revelwood.com/ibm-planning-anal ... on-editor/
Re: Changing Quick view depending on cell drop down
Posted: Mon Jun 15, 2020 6:30 pm
by 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.
Re: Changing Quick view depending on cell drop down
Posted: Tue Jun 16, 2020 2:33 pm
by kalyan846
lotsaram wrote: ↑Mon Jun 15, 2020 6:30 pm
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
Re: Changing Quick view depending on cell drop down
Posted: Tue Jun 16, 2020 5:39 pm
by tomok
kalyan846 wrote: ↑Tue Jun 16, 2020 2:33 pm
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.
Re: Changing Quick view depending on cell drop down
Posted: Tue Jun 16, 2020 8:03 pm
by lotsaram
kalyan846 wrote: ↑Tue Jun 16, 2020 2:33 pm
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?
Re: Changing Quick view depending on cell drop down
Posted: Wed Jun 17, 2020 7:20 pm
by kalyan846
tomok wrote: ↑Tue Jun 16, 2020 5:39 pm
kalyan846 wrote: ↑Tue Jun 16, 2020 2:33 pm
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
Re: Changing Quick view depending on cell drop down
Posted: Wed Jun 17, 2020 8:04 pm
by 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.
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 7:30 am
by kalyan846
tomok wrote: ↑Wed Jun 17, 2020 8:04 pm
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
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 7:34 am
by 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 ?
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 7:50 am
by kalyan846
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
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 8:24 am
by kalyan846
the dimension is fetching from B2 as you told
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 8:28 am
by 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 ?
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 8:47 am
by 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 ?
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 10:39 am
by tomok
kalyan846 wrote: ↑Thu Jun 18, 2020 8:47 am
=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.
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 10:45 am
by Wim Gielis
tomok wrote: ↑Thu Jun 18, 2020 10:39 amMaybe 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.
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 11:59 am
by kalyan846
Wim Gielis wrote: ↑Thu Jun 18, 2020 10:45 am
tomok wrote: ↑Thu Jun 18, 2020 10:39 amMaybe 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