Skip to Content

How to get account dimension member value directly ?

Hello Experts,

I had a requirement to generate a report on the base on accounts .

Having below given account

Then having a input templates as

Now want a account eNA value like below given for year 2008

But i am not getting any value in year ? i Know if i will select all the dimension as its given in input templates then i can see the value but in my report i do not want input templates values ..I need only account and entity and time nothing else in final report ..

IS it possible to get this values..

Thanks,

ravi

account.jpg (23.1 kB)
account-4.jpg (66.0 kB)
account-5.jpg (20.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 26, 2017 at 02:40 PM

    "But i am not getting any value in year ? i Know if i will select all the dimension as its given in input templates then i can see the value but in my report i do not want input templates values ..I need only account and entity and time nothing else in final report"

    Sorry but looks strange!

    You have to specify other dimensions members. It's obvous!

    Add comment
    10|10000 characters needed characters exceeded

    • "But i want to understand it so if there is 50 account to display on that case 50 different kind of input form selection need to generate to get the report ?" - sorry but how number of accounts is related to number of input forms????

      I don't understand the issue!

  • Mar 26, 2017 at 06:34 PM

    Hi Vadim,

    Not able to comment on your last comment , In my case report is having 10 account and these 10 account is connected with 10 different input templates with some different columns and rows now i need to generate a consolidated report where user can see the 10 account with reuest and proposed values now for this for each account i have to generate a same kind of input templates with same selection so that only i will get the data for a account means that i have to generate 10 different input template in to report to get the value of 10 different account ?

    is there any function or any way to achieve only account value on the basis of category time rather the create a same kind of selection to get the value ?

    Thanks,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

    • Have to repeat once again: there is NO "only account value on the basis of category time"

      If you have other dimensions (not category and time) you have to use root parent members for the mentioned extra dimensions!

      For example you have some dimension DIM1

      With members:

      PARENT1

      ...MEM1

      ...MEM2

      ...MEM3

      To get info for all members you have to select PARENT1 in report for this dimension!

      It's absolitly basic thing...