Rank question

[#1]

Hello all,

Could you please help me on the below problem that I have when I am trying to use the Rank formula.

I have the below report: where the test formula looks like this:

Test formula:

=Rank(([vdConcatenate]); ([Project Definition. -Key]); [Milestone Usage - Key]); ([Project Definition. -Key])

When I add the last part Project Definition. -Key (which is the dimension to reset the ranking) I got the below error message.

I am expecting to see the below behaviour

That means that I need to rank when the project changes and I not getting this.  Please help me.  

Thanks.

Iliana

[Former Member · Accepted solution]

[Former Member]

thanks

[Former Member]

Hello,

Thanks for your contribution, however I still get the #SYNTAX for both of the solutions you have posted.  I am using the BO 4.1 SP1.

On the other hand the dimension [Project Definition. - Key]  looks like this:

Do you think this is the problem why I am getting the syntax error message?   Or do you have any other idea or solution?

Thanks a lot for your help.   Hopefully there is another solution. 

Iliana

[Former Member]

These are not Dimension Objects. They are Detailed Objects. It is known issue tp get the #Syntax error when you use Detailed Object in the Reset Dimension.

Convert these Detailed Objects into Dimension Objects in the universe and then use them in the Rank function.

[Former Member]

Hello Rakesh,

Thanks a lot for your help. One more question.  I am using as a source a Bex query so the 98% of the characteristics are now Detailed Objects in the webi side.  Do you recommend to convert all of them in dimensions? If there is an implication that I have to know before I asked the IT team to convert all of them into dimensions?

Thanks a lot for your help.  

Best Regards,

Iliana

[Former Member]

There won't be any implications. BW team will convert the Display attribute to Navigational Attribute and that should not cause any issue I believe.

[Former Member]

Great Rakesh  and thanks a lot!

[Former Member]

Hi

Your derivation have lot of brackets. can you try the below one.

=Rank([vdConcatenate]; ([Project Definition. -Key]; [Milestone Usage - Key]); [Project Definition. -Key])

Thanks,

Sathish