Hiding of Filters in Discovery
I am using two filters, I need to hide one of them. Is there a possibility to make it hidden in discovery and not presentation.
Thanks in advance.
Jeevitha
4 replies
-
Hi Jeevitha
What is the intention of hiding a filter? I guess, it still shall filter the result set, e.g. the products in your discovery, but the user shall not change (or just not see) this filter. Is this the requirement?
If so, I have an example: In the above discover you still have a filter for "Product Category", but not for "Product" anymore. Nevertheless, the products actually are filtered - we only see black products. This is done via selecting "View Elements" from the "Product" chip and a manual selection of products (= filtering) you want to have in the discover.
So, the result set is filtered by product but you do not have a visible interactive "Product" filter - the corresponding drop zone only holds "Product Category".
Three final thoughts:
- If the dimension you secretly want to filter is not visible in your discover, i.e. if it is not in the "Columns" or the "Rows" drop zone, then Pyramid automatically places this dimension in the "Filters" drop zone - and then this filter is not hidden any more! (BTW: Why is that, or ?)
- Pro users still could change your hidden filtering via "View Elements"! I'm not sure if this is a safe way to at least prevent Viewer users from filtering.
- In a dashboard/Present you could add a filter/slicer via the "Advanced Slicer" button, even if the discover(s) which shall be filtered do not bring this filter.
Hope this helps!
Micha-
Thank you for the detailing.
However, my requirement in SQL is as
SELECT order_id, sales person, promotion category, sales region
FROM salesWhere product sub category!="Socks, Gloves, Vests"; //Hidden Filters in this query
The image when selecting necessary from the second filter is:'
The query generated in Pyramid Analytics for the pic is as below:
SELECT SUM([x_SalesData_].[Net Profit]) [xSUMmzrSalesDataNetPGO7Ev1SOsS], [x_Products__filtered].[Product Category] [x_Products___Product_Category_]
FROM [SalesData] [x_SalesData_]
INNER JOIN (SELECT *
FROM [Products] [x_Products_]
WHERE ([x_Products_].[Product Category] IN ('Accessories', 'Bikes', 'Clothing')) AND ([x_Products_].[Product Sub Category] NOT IN ('Bib-Shorts')) AND ([x_Products_].[Product Sub Category] IN ('Bib-Shorts', 'Bottom Brackets', 'Bike Stands', 'Brakes', 'Bike Racks', 'Bottles and Cages'))) [x_Products__filtered] ON ([x_Products__filtered].[ProductKey] = [x_SalesData_].[ProductKey])
GROUP BY [x_Products__filtered].[Product Category]
LIMIT 10000001So my requirement is to hide the second filter (Product sub query) because the product sub category is a static filter. I would like the user to choose only from the first filter- Product category.
Any suggestions to achieve this,
Many Thanks,
Jeevitha
-
Hi
Create a custom member in the Product Sub Categories which is an aggregate of the items you DO want to be considered in the query. Where you have a large number of elements, click on the first element, shift click on the last element to select all of them, then use ctrl-click to deselect the ones you don't want to take part, in this case, Gloves, Socks and Vests. Right click on a selected item and Create Formula / Aggregate.
I've renamed my custom member, then selected it. It appears as a background filter as it is a single member. Then make the panel zero width by dragging the separator to the right (see green box).
There is now just the Product Category to select from, but all the results will be minus Gloves, Socks and Vests.
Hope that helps!
Ian