olap query

  1. I

    OLAP Query Dynamic MDX

    Hi MrExcel Board! I'm hoping you can help me. I have a pivot table set up using an OLAP Query that I need to set up a custom MDX filter for time. I need it to dynamically update to pull the last 7 days worth of data for our subset. Can you help me figure out how to change these static dates...
  2. K

    How to set a pivot table filter from a cell for an OLAP query

    I am using Excel 2007 against SSAS 2005. I am using a pivot table to query a cube. That works well. However, instead of using contants for the filter values, I would like to use cells. My goal really is to be able to change the query by changing cells. Please, can you tell me how I can do...

Some videos you may like

This Week's Hot Topics