You could use the periods to date function which will return all members within a period up to the member specified

or try the : notation to specify a range

[member].lag(4):[member].currentmember

Switching Servers like that is fine in theory but I've not come across many companies who have an infrastructure system in place where this is feasible.

Production servers are usually subject...

(COUNT(CASE WHEN Ethnic_Origin = '' THEN 0 ELSE 1 END)/count(*))*100

What you have is fine...

Where the [1] comes to play is, suppose you have the following XML:

Residential

Woning

Home Based

when you match on...

Very good :w00t:

mjarsaniya (5/19/2009)

---

ok.

But I do not need row count i need count(name).

eg.

count(name) name surname

--------------------------------

1 ...

Are you querying a Cube or a Database

There are ways to get a VB script to go off to the internet with that URL and pull back the page title.

There is a C# method described here:

http://stackoverflow.com/questions/329307/how-to-get-website-title-from-c

Might be...

Bizarre - its not doing anything for me 😀

To answer your other question the [1] tells the XML...

select count(*), name, surname

from TableName

group by name, surname

You can use data-driven subscription or SSIS

For the SSIS method:

create a subscription to save the report to file

create an SSIS package which can test if the report is populated then...

Does that even work for you?

It's not returning anything when I run it on my test table

Each to their own I guess

Personally I prefer the step by step hand holding, repetition and over description that the books give. It's very rare to find an online resouce...

can you give some sample tables with values and expected output

blom0344 (5/18/2009)

---

Ahum,

The xml expression itself is stored as a nvarchar(max) type and not as an xml datatype. I guess that means that the xml type of query expressions will not...