This discussion is archived
2 Replies Latest reply: Sep 16, 2012 11:06 PM by 942451 RSS

Snapshot with Parameterized Query?

942451 Newbie
Currently Being Moderated
How could i call snapshot in IOP using a parameterized query.

for e.g. My MDX query is as below:

+select  {+   
+Parameter("Measure",Member,[Measures])+
+}on columns,+

non empty (CrossJoin(
+{Fiscal.[P7.2012]},+
+{Region.[NY]},+
+{Division.[56]},+
+{Commodity.[333-3333]}+
+))+

on rows
+from [Margin]+


When i try to use this query for snapshot it's giving an error.

Is there any way to make my snapshot command parameterized so that i could get data of the only measure which is required?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points