QuickView 'Where' condition

Vincent
New Contributor III

Hi the community!

Do you know the way to proceed to retriev in a cubeview a specific UD where the text of it is set on a specific value?

For example I want at the finest level all my UD1 which contain as a Text4 "Long_Lines"

I write this as a formula :

U1#Shipping_Trade.Children.Where(Text4=Long_Lines)

But nothing appears as a result. Did I missed something?

Thank you.

1 ACCEPTED SOLUTION

You should try U1#Shipping_Trade.Base.Where(Text4 Contains Long_Lines)

View solution in original post

8 REPLIES 8

= or Equals won't work, use Contains

Vincent
New Contributor III

Thank you but it didn't work, I tried with () and without :

U1#Shipping_Trade.Children.Where(Text4 Contains (Long_Lines))

U1#Shipping_Trade.Children.Where(Text4 Contains Long_Lines)

Sorry for my beginner question.

Can you post the structure? Do the children got a Text4, or are you looking for base?

Vincent
New Contributor III

I'm sure I had send a picture in my first post.

All UD1 members at finest level countains a Text4 (and we only are able to send datas at the finest level).

 

Where condition.png

You should try U1#Shipping_Trade.Base.Where(Text4 Contains Long_Lines)

Vincent
New Contributor III

Thanks it works well to have it at the finest level!

I think it is not possible to aggregate data in order to have the total of all Lines which have a Text4 as Long_Lines?

You could create a ud8 member and do it as a formula using dynamicentity agg function. Or even make that as an attribute dimension (keep in mind you'll lose a UD)

Vincent
New Contributor III

Do you work at my office? 😅

Because we already have a dynamic UD based on the Text4 and we used an UD for 2 separate hierarchy as we dont need to cross each of it at the same time.

But having it also in formule could have been a powerful tool also.

But I really appreciate your help!