Skip to main content
Newcomer
Jan 17, 2023 4:18 PM UTC
Solved

QuickView 'Where' condition

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.

Member
Jan 17, 2023 5:20 PM UTC

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

8 replies

Member
Jan 17, 2023 4:32 PM UTC

= or Equals won't work, use Contains

VincentAuthor
Newcomer
Jan 17, 2023 5:12 PM UTC

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.

Member
Jan 17, 2023 5:14 PM UTC

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

VincentAuthor
Newcomer
Jan 17, 2023 5:18 PM UTC

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

Member
Jan 17, 2023 5:20 PM UTC

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

VincentAuthor
Newcomer
Jan 17, 2023 5:28 PM UTC

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?

Member
Jan 17, 2023 5:29 PM UTC

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)