Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

reporting performance

Hi all,

We are doing reporting on BW cubes with OBI (oracle business intelligence)

When we drag two columns(0calday,0calmonth) into the report it creates the crossjoin..Please see below code generated in OBI .Due to this crossjoin reporting performance is degraded.

Can we change this to inner join?

Please provide any information/hint which can help us

With

set [0CALDAY2] as '{[0CALDAY].[LEVEL01].members}'

set [0CALMONTH2] as '{[0CALMONTH].[LEVEL01].members}'

set [DPDATDT2] as '{[DPDATDT].[LEVEL01].members}'

set [Axis1Set] as 'crossjoin ({[0CALDAY2]},crossjoin ({[0CALMONTH2]},{[DPDATDT2]}))'

select

{}on columns,

NON EMPTY {[Axis1Set]} properties MEMBER_UNIQUE_NAME, PARENT_UNIQUE_NAME on rows

from

[$DPCWCIDF]

Former Member
Not what you were looking for? View more on this topic or Ask a question