Qlik Community

QlikView Connectors

mrybalko
Contributor

SAP OLAP Connector. Limit data by attribute

Hello

I use SAP olap connector and my query is something like that:

Select

  Select PseudoMDX (

Dimensions (

  [/CPMB/B7D1SE9] ([2/CPMB/B7D1SE9], [4/CPMB/B7D1SE9], [2/CPMB/B7PZEXQ], [2/CPMB/B7P5WTV], [2/CPMB/B7P4BQT], [2/CPMB/B7P1O5P], [2/CPMB/B7P51UP]),

  [/CPMB/B7D6XTT] ([2/CPMB/B7D6XTT], [4/CPMB/B7D6XTT]),

  [/CPMB/B7DM168] ([2/CPMB/B7DM168], [4/CPMB/B7DM168]),

  [/CPMB/B7DM41D] ([2/CPMB/B7DM41D], [4/CPMB/B7DM41D]),

  [/CPMB/B7DNFN3] ([2/CPMB/B7DNFN3], [4/CPMB/B7DNFN3]),

  [/CPMB/B7DUVRF] ([2/CPMB/B7DUVRF], [4/CPMB/B7DUVRF]),

  [/CPMB/B7DVO82] ([2/CPMB/B7DVO82], [4/CPMB/B7DVO82]),

  [/CPMB/B7DZC8T] ([2/CPMB/B7DZC8T], [4/CPMB/B7DZC8T])),

Slices (

  [/CPMB/B7D6XTT].[FL_C],

  [/CPMB/B7DM168].[PLAN],

  [/CPMB/B7DNFN3].[2014.JAN],

  [/CPMB/B7DVO82].[A_PL_010101], [/CPMB/B7DVO82].[A_PL_010102]),

Measures (

  [0MEASURES0000000000000000].[/CPMB/SDATA00000000000000]), //SignData

From ($/CPMB/B7MMLPI));

Now I need to select just records having attribute [2/CPMB/B7P51UP] = D

I tried to add slice [2/CPMB/B7P51UP]. but it does not work.

Tags (2)
3 Replies
yfe
Contributor III

Re: SAP OLAP Connector. Limit data by attribute

Is [2/CPMB/B7P51UP] a navigational attribute in the infocube?

If yes, I would suggest that you filter the BEx query according to 'D' value - it will improve performance and simplify the QV extract

Yaniv

mrybalko
Contributor

Re: Re: SAP OLAP Connector. Limit data by attribute

Hello Yaniv

I would suggest that you filter the BEx query according to 'D' value

Could you please give a code example filtering value on BEx level?

Or you mean the construction:

LOAD

*

where attribute = 'D';

SELECT .... BEx query


yfe
Contributor III

Re: SAP OLAP Connector. Limit data by attribute

Hi Maxim

I BEx queries are not edited with code.

SAP-BW BI suite includes a Query Designed (graphic designer) for them

You can filter the 'D' value using the BEx Query Designer

Filtering the data in QlikView will not help you...

Thanks

Yaniv

Community Browser