Skip to main content
C
CCI01
Newcomer
July 12, 2022
Solved

Building a CV with a trailing 5 quarter view

  • July 12, 2022
  • 1 reply
  • 0 views

I'm working on a cube view that displays reporting data in a quarterly trend.

The end user would select which quarter they want displayed and the CV would display that quarter along with the 4 previous quarters. 

Ex. User selects 2022Q1 and then CV displays the following columns 2021Q1, 2021Q2, 2021Q3, 2021Q4, 2022Q1.

Data would be displayed quarterly in each column.

Any suggestions on how to write columns based on this criteria?

Thanks.

Best answer by PeterFu

Hi,

 

You can use the syntax in the print screen below. You select the quarter you want from the parameter that gets prompted. Then you will get the four prior quarters. If you use the Member Filter Builder in the Cube View, then you will find a lot of examples of dynamic references.

PeterFu_0-1657652468969.png

 

PeterFu_1-1657652493965.png

 

PeterFu_2-1657652521611.png

 

Peter

 

1 reply

P
PeterFuAnswer
Newcomer
July 12, 2022

Hi,

 

You can use the syntax in the print screen below. You select the quarter you want from the parameter that gets prompted. Then you will get the four prior quarters. If you use the Member Filter Builder in the Cube View, then you will find a lot of examples of dynamic references.

PeterFu_0-1657652468969.png

 

PeterFu_1-1657652493965.png

 

PeterFu_2-1657652521611.png

 

Peter

 

    C
    CCI01Author
    Newcomer
    July 18, 2022

    Thanks for that! 

    Terms & ConditionsAccessibility statement