reporting performance

[Former Member]

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]

Hi,

Can you go into more detail? I'm familiar with BW but not with the OBI tool. Also, how is your cube set up?