Custom data slice

[Former Member]

Hi All!

I' ve characteristics and it's attribute as separate characteristic in my cube.  I want to forbid combinations when characteristic  <> it' s attribute. How can I do it ? custom data slice? can you give me template (like this )

for example : 0PLANT = 1000 , 0PLANT-ZATR = 1

record - 1000, 1 - is open to enter

record - 1000, 2 - is not open

[Former Member · Accepted solution]

Hi,

I think that you need characteristic relationships and not data slice, try with with characteristic relationships  of type attribute.

http://help.sap.com/saphelp_nw70/helpdata/EN/43/1c3d0f31b70701e10000000a422035/frameset.htm

hope it helps.

[Former Member]

Thanks All! What about custom data slice class? can you give me template ? ( for another tasks)

[Anand71]

Hello,

Try this:

1) Craete dummy KF and select data type as Number..

2) Use FOX formula to compare characteristic and Attribute. When characteristic(ZCHAR) <> it's Attribute(ZATTR) then KF = 2 otherwise KF = 1.

3) Create query for ZCHAR and  dummy KF. In query use exception to get all the value of ZCHAR when KF=1.

4) Create a variable for ZCHAR and get  values in variable using replacment path. Use above query in replacement path.

5) Use the above variable in data slice.

regrads,

Anand Kumar