Hi,

I am using Analysis Service 2005............

I want to show data trend on comparison of last month and this month. How i
can show the trend for todate for example

Today is 15 November........so Trend should be comparing data of last month
(1 to 15) with current month (1 to 15).

How do i define a KPI for this requirement??

Last Month this month
60 records 35........... but it is only
15th.........so if i compare 35 with 60 then it does not make sense so
comparison should be with data of last month till 15 with till 15 of this
month................

any idea???????

Regards,

BizWorld

You can use the ParallelPeriod() function to get the same time last
month

so if your Time.CurrentMember is Nov 15, ParallelPeriod(Month,1) will
return Oct 15.

The other issue is determining what you mean by the current date. Often
people end up getting the last non-empty member of the descendants of
the current time member at the day level.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <ux3bqPl6FHA.3136 (AT) TK2MSFTNGP09 (DOT) phx.gbl>,
moonis.tahir (AT) gmail (DOT) com says...

Thanks for the reply,

Can you provide little bit more help on this,

can i do this using Calculated member.........Secondly to show a trend on
basis of comparison with last month or last week according to todate......do
i need to define two calculated members in which one will pick value for
last month 15 days and one calculated member will pick value of this month
15 days......
then in KPI we can show a trend on basis of these two calculated
members.......???

I really appreciate that you are providing valuable information on this
subject.

Regards,

BizWorld

"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> wrote

Yes, this would work as two calculated members.

Although if your end users did not need to see these figures directly
you could also calculated then straight in the KPI. (The Adventure Works
sample has a few KPIs in it with case statements and nested expressions)

One other thing to consider is be how these members should work in
relation to the date hierarchy. I don't know how you date dimension is
structured, but it's not uncommon for people to have Year-Quarter-Month-
Day hierarchies. So if you are at the Year or Quarter level, do you want
to see a Year to date or Quarter to date amount or will you just return
an empty cell?

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <OvaqEys6FHA.4012 (AT) TK2MSFTNGP14 (DOT) phx.gbl>,
moonis.tahir (AT) gmail (DOT) com says...

In my scenario, time dimension has Year, Quarter, Month, Week.

Requirement is to show Last week comparison with this week comparison
toDate.

I created a calculated member with simple Sum(WDT(), measures.Actual) it is
returning me WTD so it will work for this week.

i am thinking that i need to create another measure to calculate previous
week WTD...means if it is 47 week
then 47 Week will have a calculated value to show last week WTD sum of
amount............

so this time, i just want to show on Week level........it will be ok if it
is empty on Quarter of Month level............

it means i will have two measure one is showing this Week TD and other one
will showing last week YTD........

so any front end can easily do a comparison on these two calculated
members.............

i will check Adventure works...............

"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> wrote