#Multivalue problem ---Can we do index() for each item in Dimension?

[Former Member]

I have a dimension called [Salesmen Name].

This is giving me error.

Can we do like index number to specify items in the array of dimension....?

[Salesmen];(0)

[Salesmen];(1)

[Salesmen];(2)

[Salesmen];(3)

[former_member207052 · Accepted solution]

Regarding Multivalue error, check this thread. https://scn.sap.com/thread/1919325

If you can't figure out the problem, post the sample data.

Are you trying to access nth element of a dimension? again, If you can post sample data and specify what you are trying to achieve someone might be able to help. In Web-I we have row index which can return you the row number ranging from 0 to N.

[Former Member · Accepted solution]

Dear Narashimman,

Thank you for your reply.

I have a table like below:

*Referral Names

-can be more than 1 value

-is a Detail Dimension  (Guest ID is merged)

**********************************************************************************************

1. I tried avoid aggregation tick box and it shows all the values.

That is 1 possible solution.

2. RowIndex...

I will try if I can specify context for RowIndex. For example:

RowIndex([Referral Names]) In ([Guest ID])

I can then make a variable like

Index (1) = [Referral Names] Where ("[RowIndex]=1")

Thank you...

[Former Member · Accepted solution]

Hi,

If you want to show 1st row for each Referral names object, then you can try like below.

Add a column and put a variable with definition var1=runningcount([referral names] and reset it for each guest (if the data is at guest level)

i.e. runningcount([referral names];([Guest Name]))

then filter the rows with var1>1

and hide the column which is giving var1

[Former Member · Accepted solution]

Wow thank you for this solution!