Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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].
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
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
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