Skip to Content
author's profile photo Former Member
Former Member

How To Handle The GL wise Restriction which is done in BI Query for dashboard Designing

Dear All,

I have to design the following dashboard.



In above Dashboard the challenge is in Bi query format is like as shown below (For example showing in excel)

As explain above for assets & Liablities as well as further more fsv nodes Bi consultant is going restrict as per the GL wise at Bi query level. So i thing will get Cash, Account Receivable.net, Prepaid Expenses & other etc as individual characteristic at BO level so hwo should i arrange them all in one column.

So can any one pls tell how to handle such requirement?

Thanks & Regard,

Rohan Ghadi

Untitled.jpg (127.4 kB)
Untitled.jpg (88.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 03, 2013 at 04:56 AM

    Can any one pls suggest any solution for this.

    Regards,

    Rohan Ghadi

    Add a comment
    10|10000 characters needed characters exceeded

    • Okay i would suggest to map this Dimension and key figure column wise(like Company code, Plant, Month, Cash, Receivables, prepaid receivables, total asset ... n) and have two level destination for company code and plant. Once you drill plant and data will be fetched like the first image in screen shot. Then change it to row wise(second image) using '=' in all cells or use some excel functions

      This is how we are using in our dashboard modules. Hope it will help.

      Thanks

      Untitled.png (18.1 kB)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.