I thought I would share a quick tip from this great eBook which only costs $24.99 USD.
I never noticed this before with Analysis OLAP but there is a nice filter bar available while you build your Analysis workspace:
Figure 1 shows the arrow next to the filter bar.
So let’s say we want to add the Project characteristics to the row of the cross tab, I select the Project dimension, then select the icon “Add to rows of the selected cross tab or chart”
Figure 3 shows that Project has been added to the rows of the cross tab.
The icon to the right will add to the columns of the cross tab.
Figure 4 shows the 3rd icon, add to the background filter (filtering on something that is not shown in the crosstab).
I select Load date, and then I am prompted to select a date to filter by (load date is not in the cross tab)
I select the date I want to filter by in the background.
I learned this quick tip by reading Ingo Hilgefort’s eBook which you can purchase from iTunes or the iBooks store. I know I have learned a great deal already.