There are ways of defining the range yourself

You can either hard code it or use an expression

There are some really good tips about charting here:

http://msdn.microsoft.com/en-us/library/aa964128.aspx

rodjkidd (5/21/2009)

---

Cats: We had a great cat when I was growing up. If he could get into your room in the morning he would sit at the end of the...

http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139/ref=sr_1_1?ie=UTF8&s=books&qid=1242899563&sr=8-1

A lot of these Microsoft books come with a companion CD rom which also has the e-book on it which is very handy

22 out of 30 people gave it 5/5

My cat was up to...

Tom Bakerman (5/20/2009)

---

Come on, give me a little credit. I mean: Ok, I find the database object I'm interested in in the XML. How do you find that...

This is a good example of why proper naming of objects it a good idea!

To find where a table is being referenced you could open the code page - right...

you'll need the reporting services service to be active and configured

try browsing to

http://YourDatabaseServerNameGoesHere/reports

you should see the home screen for the reporting services web front end

at the moment you have an MDX query in a data source

something like

with member [measures].[mymeasure] as

Sum(Lastperiods(3,head(strtoset(@DimDateTimeCalendarMonthNo))))

select

[measures].[mymeasure] on 0,

[dimension] on 1

from [mycube]

This will need to...

Assuming that the variable is being converted to a set then HEAD is the right function to use

I don't think that your variable is being converted though, try this syntax...

Whats this variable @DimDateTimeCalendarMonthNo from?

Try this:

select itm.* (...)

from L_ITEMS itm (nolock)

left outer join EDI_ADRESSES EDI

on EDI.SENDER = ITM.SENDER

and EDI.operator = @operator

You could try this:

select '' as "retainedDataMessage/retainedDataPay/statusMessage/StatusResponse/requestStatus/InvalidReq"

FROM ##StatusUpdates

where RequestStatus = 'InvalidReq'

FOR XML PATH('')

There probably is a far better way to do it though, so keep the question open 😀

Good stuff

Don't forget - that when using a calculated member then the currentmember could be year, quarter, month or day

So if you use the currentmember on the time hierarchy but...

You can use the average function

with member [measures].[month avg] as

avg({[Time Dimension].[Hierarchy Name].currentmember.siblings}, [measures].[charges measure])

Marcus,

I think you misunderstood

In MDX you can specify a range as

([Time].[Years].[2009].[Feburary]:[Time].[Years].[2009].[May])

This will give a set with all members:

[Time].[Years].[2009].[Feburary]

[Time].[Years].[2009].[March]

[Time].[Years].[2009].[April]

[Time].[Years].[2009].[May]

So to do this range dynamically you can use

([Time].[Years].[2009].[May].lag(4) : [Time].[Years].[2009].[May])

or in an...