Issue with the QvEssbase Connector

nenadvukovic — Mon, 23 Feb 2015 17:35:43 GMT

Hi - This MDX statement works fine when run from Excel SmartView add-on

select {[SalesDollars], [SalesUnits]} on columns,

non empty {CROSSJOIN({Descendants([PC_CEntity], 5, Leaves)}, CROSSJOIN({Descendants([PC_CCustomer], 4, Leaves)}, CROSSJOIN({Descendants([PC_CProduct], 3, Leaves)}, CROSSJOIN({Descendants([CYears], 1, Leaves)}, {Descendants([CPeriods], 3, Leaves)}))))} on rows

from LNENAD.LNENADR

where ([R_CEntity].[NoMember], [R_CDepartments].[NoMember], [R_CAcctGrp].[NoMember],

[A_CEntity].[NoMember], [A_CDepartments].[NoMember], [A_CActivity].[NoMember],

[P_CEntity].[NoMember], [P_CProcess].[NoMember], [P_CProduct].[NoMember],

[C_CEntity].[NoMember], [C_CProcess].[NoMember], [C_CCustomer].[NoMember],

[CScenario].[Actual])

But, when I run it from the QV script I get this:

If I replace the ‘{…} on rows’ part with this {CROSSJOIN({Descendants([R_CEntity], 5, Leaves)}, {Descendants([CYears], 1, Leaves)})} on rows then

then it runs fine in QV also.

Because it runs fine from Excel I assume that the cube definition does not affect this.

What to look at?

topic Issue with the QvEssbase Connector in QlikView

Issue with the QvEssbase Connector