Modified row script MDX to convert from full-query to two steps.
`WITH
SET [Step1] AS
{
(
Descendants([TCE99999 - Current EBIT])
[TCE99999 - Current EBIT]
[TCP99999 - Commercial Profit]
[Total Other Commercial]
[GRP99999 - Gross profit]
[GRP24000 - Net Sales]
[TDC99999 - Direct contribution]
[TME99999 - Total Marketing Dept]
)
Descendants([Clarins Brand],,Leaves)
Descendants([All SubAccounts],,Leaves)
}
SET [Step2] AS
{
(
Descendants([TCE99999 - Current EBIT])
[TCP99999 - Commercial Profit]
[Total Other Commercial]
[GRP99999 - Gross profit]
[GRP24000 - Net Sales]
[TDC99999 - Direct contribution]
[TME99999 - Total Marketing Dept]
)
[Clarins Brand]
[All SubAccounts]
}
SELECT
{@cols} ON COLUMNS,
NON EMPTY Hierarchize
(
{NonEmpty([Step1]@cols) + NonEmpty([Step2]@cols)}, POST
)
ON ROWS
FROM [@cube];`
Modified row script MDX to convert from full-query to two steps.
`WITH SET [Step1] AS { ( Descendants([TCE99999 - Current EBIT])
Descendants([Clarins Brand],,Leaves)
Descendants([All SubAccounts],,Leaves) } SET [Step2] AS { ( Descendants([TCE99999 - Current EBIT])
[Clarins Brand]
[All SubAccounts] } SELECT {@cols} ON COLUMNS, NON EMPTY Hierarchize ( {NonEmpty([Step1]@cols) + NonEmpty([Step2]@cols)}, POST ) ON ROWS FROM [@cube];`