11-15-2022
02:58 PM
- last edited on
05-02-2023
10:35 AM
by
JackLacava
Hi,
Is there a way where users can input From and To dates time members in a cube view? Currently, I am using a parameter in the time member field in POV section of cube view.
I have a business rule with FROM and TO dates (2022M1 to 2022M4) and then extract all the periods within (2021 M1 M2 M3 and M4) that time frame in a dt.
And now, I want to incorporate this function in the cube view. feel free to drop your inputs.
Solved! Go to Solution.
11-15-2022 06:20 PM
Hi KAC: sounds like you're most of the way there. You'll move the time selection to the column (or row) section of your Cube View so that it can expand into multiple periods (the fixed POV only allows for a single selection). To get your member expansion across the finish line so it can be used in the Cube View you'll need to:
That said, I would strongly encourage you to explore the standard member expansions before going the custom route. The out-of-box member expansions are super slick and cover >90% of our reporting needs. We've found using out-of-box functionality easier for our report writers to comprehend and maintain. You can even put the member expansion selection into its own parameter (delimited list). Time Member Expansions that come to mind:
11-15-2022 06:20 PM
Hi KAC: sounds like you're most of the way there. You'll move the time selection to the column (or row) section of your Cube View so that it can expand into multiple periods (the fixed POV only allows for a single selection). To get your member expansion across the finish line so it can be used in the Cube View you'll need to:
That said, I would strongly encourage you to explore the standard member expansions before going the custom route. The out-of-box member expansions are super slick and cover >90% of our reporting needs. We've found using out-of-box functionality easier for our report writers to comprehend and maintain. You can even put the member expansion selection into its own parameter (delimited list). Time Member Expansions that come to mind:
11-19-2022 04:17 AM
Hi db_pdx
Thank you for this information, I will use it in some cases. It seems that I don't need to do anything related to cube view since the FDX adapter only references this CV.