Solved

QuickView 'Where' condition

Forum|Forum|3 years ago
January 17, 2023
3 replies
0 views

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.

Cubes

Best answer by ckattookaran

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

= or Equals won't work, use Contains

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?

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

ckattookaranAnswer

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

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)