cancel
Showing results for 
Search instead for 
Did you mean: 

How to pass 0calyear based on ycalmonth on cube using customer exit variable?

Deepika4
Discoverer
0 Kudos

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

OpCoVersionYCALMONTH0CALYEAR0CALMONTH2Quantity
poland70012.2023202312150
poland70012.202320241160
poland70012.202320242170

Version 100 data in cube

OpCoVersion0CALMONTH0CALYEAR0CALMONTH2Quantity
poland10012.2023202312180
poland1001.202420241190

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 - 0CALYEAR2023 20242024
columns - version700100700100
rows - CYLYCYLY
 150180160190
   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

BW Business Explorer (SAP BEx) 

View Entire Topic
Deepika4
Discoverer
0 Kudos
Report
columns - 0CALYEAR2023202320242024
columns - version700100700100
rows - CYLYCYLY
 150180160190
   170