Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all!
I am facing a little challenge trying to figure out the best approach for solving this problem. I have a QS custom extension that accesses the source data via measures and dimensions (feeding X & Y axis data in my custom chart control). All of this works fine, however, I also have a lookup table in my source data that has a list of all available measures and dimensions, and corresponding metadata for each measure (like "Friendly Name" etc.) What is the best way to access this lookup table in my custom extension code? Ideally, I'd like the ability to query this lookup table in the extension code to get the list of metadata for the selected measure and dimension. I need to look this metadata up every time the user configures the measure or the dimension for the custom extension.
Thanks!
Can you please try below formula
=$(=FirstSortedValue([Dimension] ,[Dimension Position],1)) in Field and
=FirstSortedValue([Dimension Name] ,[%Dimension Position],1) in Lable
Hope this help you to get the desire output.