difference between static and dynamic set analysis

[SunilChauhan]

Dear all,

what is difference between static and dynamic set analysis.

can any one help me to write syntax in set analysis

regards

Sunil

[deepakk]

Hi,

As per my understanding Static means getting value for a fixed record.

Eg : Sum ( {<Type= {A}>} Sales)

Here I am fixing my Sales Value to Type A.

Dynamic : Here the value will change as per user selection.

Sum ( {<Year={$(=Max(Year)-1)}>} Sales )

In the above example the value of Year will change based on user selection .

Eg :If user selects 2010 then the it will show value of 2009

You will find more examples in help

[#3]

I cannoot figure out whey this wont work.  when I used a variable and hard coded -13 into the variable it worked.  But when i try to either assign Max([# of Months from Current Month])-13 to the variable or hard code it in as below, it does not work.  I can see the value of the variable = -13 via a text box, but it wont work in the formula.  What am I missing?

count ({<[# of Months from Current Month]={$(>=Max([# of Months from Current Month])-13)}>} distinct [Order Number])

[deepakk]

hi,

Your syntax is incorrect. Use the below one

count ({<[# of Months from Current Month]={"<=$(=max(([# of Months from Current Month])-13)) "}>} distinct [Order Number])

I think the above code will work fine.

Deepak

[#5]

Thank you!  That worked.  I just changed the <= to >= and it worked beautifully! Maybe you can help me with one other question.  When the user filters to any month or Quarter, i want the chart to maintain the last 12 months regardless.  However, when the filter down to one partner, I want the chart to stay 12 months but filter to only that partners data. would putting in [Fiscal Month]=,Fiscal Quarter]=, into set analysis do that trick.

[deepakk]

Yes That should do the trick.. . Logically what ever the field name user will select you need to ignore that.

Deepak