I want to allow users to input a text field with items separated by commas (e.g.,
X1,X2,X3,X4,X5
) and, after clicking a boolean (e.g., "Select"), have the page filtered to show data only for the specified items. How can I set up this filter?
Hi, I think we need a bit more information of what X1, X2 is representing. If those are list members then I would sugest this solution instead. 1) Have a Boolean added to an ADMIN module (no dim). ("confirm choice/select") 2) Have a module (FIL01) dimensioned by your list 1 "Filter Line item" (formatted as a boolean) = should have no formula 2 "Filter Confirmed Picks" = If not "ADM01.select" then true/false (depending on how you want it to operate) else "Filter Line Item" Here they can select the items manually (instead of typing). Still want to add typing? Add SYS Lookup: "Item to find" (formatting text) Then you can add another filter to FIL01 "Find Item" = Name(item(L1)) = sys lookup.'item to find' Then add this as a filter to the UX-card. This would allow users to search for an item, then check the boolean and search for another item. You could add a lot more logic to have a dynamic search function, but this is probably the most you need. Does this work for you? Best, Rickard
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…