0 Replies Latest reply on Oct 8, 2008 3:19 PM by FlexTester

    OLAP Queries with Different Measures

    FlexTester
      I seem to be having a problem when I run multiple queries against one cube where one query looks at the default measure and the second looks at a different measure. The problem that I am having is that when I try to change the slicer on the first query (by changing a menu selection) after running the second query my dg showing the first query dissapears.

      Please see the code attached below. On the left hand side there is a tab labeled Run Queries which I have added to help with testing. You can build the cube and run my two queries using the buttons provided. Note that the "Filter Demand Query" button does nothing right now. Clicking "Demand Query" will return an aggregate of all of the forecasts in the OLAPDG in the Demand: Forecasts accordian pane. This part works fine.

      You can then change tabs to the Model tab, choose from the models in the tree and a slicer will change the dg accordingly by the selected model. The problem comes after running the next query. Click the Run Supply Query button. This runs a different query against the same cube but on another measure, the Inventory measure. The result is shown in a different dg in the Supply: On hand, In coming accordian. This query actually works fine.

      However, if you now flip back to the Demand: Forecasts accordian and dg and try to change the model in the tree, the whole content of the dg dissapears! What is going on? It seems to be related to the slicer used to switch measures because if I comment that out and instead keep the defualt measure, the problem goes away. What is weird is that these are separate query variables. Why does one affect the other? Please help!