Forum Discussion

Vincent's avatar
Vincent
New Contributor III
3 years ago
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 co...
Cubes
  • ckattookaran's avatar
    ckattookaran
    3 years ago

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

ckattookaran's avatar
ckattookaran
Valued Contributor
3 years ago

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

Vincent's avatar
Vincent
New Contributor III
3 years ago

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?

  • ckattookaran's avatar
    ckattookaran
    Valued Contributor
    3 years ago

    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's avatar
      Vincent
      New Contributor III
      3 years ago

      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!