This repository has been archived by the owner on Jul 24, 2019. It is now read-only.
This repository has been archived by the owner on Jul 24, 2019. It is now read-only.
dynamically filtering data #193
Open
Description
How would you recommend filtering all cubes and reports by store name for example
SELECT NON EMPTY {[Measures].[Profit], [Measures].[Store Sales]} ON COLUMNS,
NON EMPTY Order(Order({[Store].[USA].[CA].[San Diego], [Store].[USA].[CA].[Beverly Hills],
[Store].[USA].[CA].[Los Angeles]}, [Measures].[Profit], DESC), [Measures].[Profit], DESC)
ON ROWS FROM [Sales]I am new to mdx but for this query adding the dimension to order works.. but I don't see how to do this when the report loads..
Trying to work out how to have 1 cube and filter by user org chart