DYNAMIC QUARTER

Previous Member

Hi there,

 

Hope someone can help.  I am developing a number of financial reports which require a quarterly summary.

I am building the report in the same view.  I'm finding that I need to use a 'Refer To' statement on Quarter so that I can summarise data for Q1/19 for example.  Herein, lies the issue.  Next year the report will still be stuck on Q1/19 rather than update to Q1/20.  I have approx 60 examples of this on the one report so I need to find a solution.

I'm aware that there is the ability to create some custom data fields but we have apparently used our quota of these.

 

I really need some way of selecting the quarter without the year portion and then I could always make the year available in a Select.  Is there any way of doing this in BOARD?

 

Thanks, 

Siobhan

unknown

Hi Siobhan Buckley

 

When you refer to "custom data fields", are you referring to Defining custom time entities? Because that's probably the easiest way to model it, having a custom time entity with members like "Q1 Current Year", "Q2 Current Year",... So by adjusting the relationship between your months and this custom time dimension, all your tables get updated correctly.

 

If not available, you might look into the procedure steps, which dynamically run the "refer to" from a procedure: Block Selections. With that approach, you would have to run a procedure running these block selections every time you enter in the screen, which is performance wise not the best solution, but it's a valid workaround.

 

All the best,
Jonathan