Group Links do not seem to work in BIP 11.1.1.5
Create a new Data Model in BI Publisher called USC Model2
Add a new MDX Query Data Set to the model based on the following MDX query
With
set [_ACCOUNTS0] as '{Descendants([Accounts].[Total Income .])}'
SELECT
CrossJoin(
CrossJoin(
CrossJoin(
{[Currency].[GBP]},
{[Splits].[Total Input]}),{[Year].[2010]}),
{[Organisation].[Barclaycard Total]})
ON PAGES,
{[_ACCOUNTS0]} properties ANCESTOR_NAMES, GEN_NUMBER, [Accounts].[LEVEL_NUMBER] ON ROWS,
{[Scenario].[Actual]} ON COLUMNS
FROM [DB_ERNIE.ERNIE_V1]
WHERE {[Version].[Report]
Add another MDX Query Data Set to the model based on the following MDX query
With
set [_ACCOUNTS0] as '{Descendants([Accounts].[Total Income .])}'
Add a new MDX Query Data Set to the model based on the following MDX query
With
set [_ACCOUNTS0] as '{Descendants([Accounts].[Total Income .])}'
SELECT
CrossJoin(
CrossJoin(
CrossJoin(
{[Currency].[GBP]},
{[Splits].[Total Input]}),{[Year].[2010]}),
{[Organisation].[Barclaycard Total]})
ON PAGES,
{[_ACCOUNTS0]} properties ANCESTOR_NAMES, GEN_NUMBER, [Accounts].[LEVEL_NUMBER] ON ROWS,
{[Scenario].[Actual]} ON COLUMNS
FROM [DB_ERNIE.ERNIE_V1]
WHERE {[Version].[Report]
Add another MDX Query Data Set to the model based on the following MDX query
With
set [_ACCOUNTS0] as '{Descendants([Accounts].[Total Income .])}'
0