on 03-03-2024 8:28 AM
Helli Everyone,
I have a requirement that to pass 0calyear based on ycalmonth on cube using customer exit variable. In cube we have data as below.
Version 700 data in cube
OpCo | Version | YCALMONTH | 0CALYEAR | 0CALMONTH2 | Quantity |
poland | 700 | 12.2023 | 2023 | 12 | 150 |
poland | 700 | 12.2023 | 2024 | 1 | 160 |
poland | 700 | 12.2023 | 2024 | 2 | 170 |
Version 100 data in cube
OpCo | Version | 0CALMONTH | 0CALYEAR | 0CALMONTH2 | Quantity |
poland | 100 | 12.2023 | 2023 | 12 | 180 |
poland | 100 | 1.2024 | 2024 | 1 | 190 |
In the bex query created a YCALMONTH based variable of manual input. If user enters 12.2023 as YCALMONTH, it means we are having 0CALYEAR's are 2023 and 2024 for YCALMONTH.
In for V100 if we have 2023 and 2024 as 0CALYEAR.
Question: In LY column how to pass 0calyear's based on ycalmonth's - 0calyear's on cube using customer exit variable?
Report | ||||
columns - 0CALYEAR | 2023 | 2024 | 2024 | |
columns - version | 700 | 100 | 700 | 100 |
rows - | CY | LY | CY | LY |
150 | 180 | 160 | 190 | |
170 |
So, how to write a customer exit variable to fetch 0calyear's of specific ycalmonth on cube and those 0calyear's: 2023, 2024 in V100 to pass to a variable.
BW SAP HANA Data Warehousing
Report | ||||
columns - 0CALYEAR | 2023 | 2023 | 2024 | 2024 |
columns - version | 700 | 100 | 700 | 100 |
rows - | CY | LY | CY | LY |
150 | 180 | 160 | 190 | |
170 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
10 | |
10 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.