Issue in hierarchy

Fri, 05 Oct 2012 13:29:42 GMT

Hello,

We have a product hierarchy Category -> Product Group -> Product (Using hierarchy function we are building this)

We have the sales detail at both Prodcut and Product Group level and forecast at Product Group level. And both metrics are displayed in a same chart.

If we choose any Product in the report, Forecast values will not be shown in the chart since it is at Product Group level.

Now the requirement is,

we need to show the forecast detail for the product groups under which the selected products are in.

Re: Issue in hierarchy

whiteline — Sat, 06 Oct 2012 10:11:13 GMT

Hi.

Transform your data model to use different keys for sales (products) and for forecasts (product groups).

Look for hierarchy statement at help and reference manual.