Skip to Content
0

Drill Down in the Excel Planning views

Mar 31, 2017 at 09:40 AM

56

avatar image
Former Member

Hello Team,

We got a requirement that user wants to view the values at a Location Region basis (aggregated level) and can drill down to further detailed Location level (Individual locations that are mapped in that region)

Master data was configured appropriately.

But when we open the planning view at Location region level and double clicking on it, getting the below error "The Bottom level has been reached, can't expand to a lower level"

Am i missing anything here ?

Thanks

venkat

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lingaiah Vanam Mar 31, 2017 at 11:47 AM
0

Hi Venkat,

Select Location Region only and remove Product and UOM load the planning view. Later drill down by attribute based on your requirement.

That message is bottom level is reached you can not drill down to another. You should select the planning view value and choose the drill down option.

Best Regards,

Lingaiah

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello again boss

Followed as per suggestions. But still it didn't worked with one aggregated attribute i.e Location Region.

Do i need to configure this drill down functionality anywhere like in Analytics, where we specify the Drill down links between the charts ?

Thanks

venkat

0

Hi Venkat,

Can you select time dimension (Week, Month) in planning view and right click you will get drill down option by attribute.

Best Regards,

Lingaiah

0