01-17-2023 11:18 AM - last edited on 05-03-2023 09:05 AM by JackLacava
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.
Solved! Go to Solution.
01-17-2023 12:20 PM
You should try U1#Shipping_Trade.Base.Where(Text4 Contains Long_Lines)
01-17-2023 11:32 AM
= or Equals won't work, use Contains
01-17-2023 12:12 PM
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.
01-17-2023 12:14 PM
Can you post the structure? Do the children got a Text4, or are you looking for base?
01-17-2023 12:18 PM
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).
01-17-2023 12:20 PM
You should try U1#Shipping_Trade.Base.Where(Text4 Contains Long_Lines)
01-17-2023 12:28 PM
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?
01-17-2023 12:29 PM
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)
01-17-2023 12:32 PM
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!