Difference between revisions of "Set Searching"
(Created page with "==Member Search== In v6.5 there is a new functionality that allows the user to filter a report by searching for members in a hierarchy. The report below shows a simple grid with...") |
(→Member Search) |
||
| Line 16: | Line 16: | ||
At this point you have three options: | At this point you have three options: | ||
| − | + | ||
| − | + | #enter a value in the Search Value field – in our example we enter B as we want to report all members whose name starts with the letter B | |
| − | + | ||
| + | #click the ellipse and add some filtering using MDX | ||
| + | |||
| + | #use Excel range to hold the value that should be used | ||
| + | |||
In our example we are using the value in cell F2 to determine the filtering on our report. | In our example we are using the value in cell F2 to determine the filtering on our report. | ||
| + | |||
You can also determine the ‘search by’ criteria as below: | You can also determine the ‘search by’ criteria as below: | ||
Revision as of 15:58, 26 October 2011
Member Search
In v6.5 there is a new functionality that allows the user to filter a report by searching for members in a hierarchy. The report below shows a simple grid with Geography on rows and Fiscal Years on columns.
We would like the report to only show those members on Geography whose name begins with B. We can edit the Geography hierarchy and click on Advanced tab.
Then, click on Member Search and the following window will be displayed.
At this point you have three options:
- enter a value in the Search Value field – in our example we enter B as we want to report all members whose name starts with the letter B
- click the ellipse and add some filtering using MDX
- use Excel range to hold the value that should be used
In our example we are using the value in cell F2 to determine the filtering on our report.
You can also determine the ‘search by’ criteria as below:
The Advanced window is now displayed as:
