I was wondering if you knew how to accomplish this. I am exporting into a .csv a multidimensional cube. I want my measures to be across the top - in this case, they are Expense, Cost Per Module, and Cost Per Component. I've accomplished that - no problem. However, it's doing it in a line per measure versus just combining (see my example). This typically wouldn't be a big issue, but this cube is quite large and that will 'eat up' a lot of space needlessly.
Am I almost there?
Basically, all my code is on my Data tab and is as follows:
Code: Select all
#****Begin: Generated Statements*** vExpense= IF (Measure @= 'Expense' , Value , '' ); vCostPerModule= IF (Measure @= 'Cost per Module' , Value , '' ); vCostPerComponent= IF (Measure @= 'Cost per Component' , Value, ''); #****End: Generated Statements**** IF (Header = 1); # Following are column header names ASCIIOutput('\\analyst-app\libraries\TM1\BU\SIG\SIG Module Cost 2.csv', 'Month' , 'Site' , 'Expense Type' , 'MPN' , 'Expense' , 'Cost per Module' , 'Cost per Component' ); ENDIF; # Following are variables from the variables tab of this process ASCIIOutput('\\analyst-app\libraries\TM1\BU\SIG\SIG Module Cost 2.csv', vMonths, vSite , vExpenseType , vMPN , vExpense , vCostPerModule , vCostPerComponent ); Header = Header -1;