Author Topic: Default value in Financial Period Prompt  (Read 511 times)

Offline colt

  • Full Member
  • ***
  • Posts: 21
  • Forum Citizenship: +1/-0
Default value in Financial Period Prompt
« on: 07 May 2010 09:05:15 pm »
Hi,
in my report I have a Prompt to chose Financial Period which is part of the DATE Dimension within a cube.
I want this prompt to default to the last closed period. That means if actual date is in MAY, the last
closed period is 04. Due to Budget-Data, there are also future Periods within the selection of the prompt.
Therefore it's not just a question of sorting data descending and taking the first entry.
Default value should be valid for all ouptut-formats. (HTML,PDF,...)

Any ideas how to solve this ?