Analytics Software

1 error has occurred

Your session has timed out.

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Form data issue in PBCS

Thulya PereraFeb 14 2018 — edited Feb 17 2018

Hi All,

I have a concern on the data displayed in the forms. Our entity dimension hierarchy is as follows,

Entity

 Total Department

      Sales

           Sales East

           International Sales

 Regional Sales

      Region 1

           Mid East

I have uploaded data to International sales and Sales east cash accounts. When I am querying the balances entering the POV for entity dimension. Some of the data are not displayed. As example, I entered International sales as the POV value for entity dimension and it is displaying accurately and it is rolled up to sales and total department parent level as well. But when I enter the entity as POV for the entity dimension, data is missing in the form.

My concern is why the child level values are not rolled up to the ultimate parent level.

Refer the screen shots attached on setups.