BI Publisher (MOSC)

MOSC Banner

Group Links do not seem to work in BIP 11.1.1.5

edited Jun 23, 2011 7:01AM in BI Publisher (MOSC) 1 commentAnswered
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 .])}'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center