Forum Stats

  • 3,839,372 Users
  • 2,262,486 Discussions
  • 7,900,955 Comments

Discussions

FR - Issue

Hi All,

I'm facing two issue in Financial Report in PBCS

1.

Current report contains multi –grid and multi-database connections. I have prompts for ‘Period’, ‘Years’ dimension. The issue here is, since it is multi-database the prompts are repeated for each dimension more than once. From user stand point it is very confusing to choose the same members so many times. Is there any workaround for the prompts to appear only once.

(I have made sure to keep the default members and limits same. I have also enabled ‘Merge report prompts’ in FR preferences.)

ss.png

2. Report function ‘Left Siblings’ of a specified member, creates dynamic rows in the report. I need to pick up the values that are being generated from the function into formula rows.

Is there any way to reference these dynamic rows?

ss.png

Any help would be really appreciated.

Thanks,

Azad Singh

Tagged: