Forum Discussion
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.
You should try U1#Shipping_Trade.Base.Where(Text4 Contains Long_Lines)
8 Replies
= 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).
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)
