top of page

MicroStrategy Qualifying Attribute Element Selector

I'm very active on the online MicroStrategy community. Recently someone asked how top create a qualifying attribute element selector (at least that's what i'm calling it). The community member gave an example of a data set with Pizza and it's corresponding topping - both attributes. The use case was to have an attribute element selector for the toppings and only display the Pizza's which qualify on all of the selected option.


The solution I came up with requires 3 Elements

  1. A Metric to count all the available/select toppings

  2. A Metric to count the toppings for the individual Pizza

  3. A view filter to marry the two


Counting All the Topping

Here I created a level metric which counts all of the Toppings at the dataset level



Counting Topping on Individual Pizza'a

Here I created a level metric to count the toppings at the pizza level


Marry the two

I can now place a view filter on grid that is "All Pizza Toppings" = "Individual Pizza".



Viola! If you'd like to see this in action watch the video below.





 

Thanks for checking out this blog post. If you found this post helpful please consider donating. Any contribution is appreciated! Just click the PayPal icon at the bottom of this page.







655 views3 comments

Recent Posts

See All

3 Comments


Is there a way to create a custom sort order in my element dropdown? For example my dropdown contains High, Low, Medium (alphabetically, default), but I want it to show High, Medium, Low instead of alphabetically. Is that possible?

Like
Replying to

I guess I need more help. I've never worked with DESC forms and Google isn't really doing it (or I don't know what to search for). This is the derived attribute I came up with so far:


Case((Length([Max NOP Level]@ID)>0), [Max NOP Level]@ID, "No NOP")


"Max NOP Level" has the options "High", "Low", "Medium" and I'm adding "No NOP" if Max NOP Level is blank. When I click the plus next to the ID to add a DESC, I'm completely lost. I'd like the display list in my dropdown attribute selector to show "No NOP, High, Medium, Low" in this order.


Could you maybe create an attribute DESC blog post in the future?


Thank you for your help!

Like
bottom of page