The idea behind this is to create a BI demo based on an insurance data warehouse not as an actual aid to a situation 😉

Cheers

Very neat tool and a very neat article 🙂

Thank you

I am specifically looking for insurance dw sample database. Looked at AdventureWorks but business is completely different.

At the moment I am more looking into a 'generic' model to continue building on that basis, possibly with sample data which is ready to do some analysis models...

Great refresher 😉

Thanks

Hi Eugene,

How can I escape the special characters (<, >, &) in XQUERY and successfully parse the XML ? The unfortunate thing is that I cannot ask the source to...

Hi guys,

I am getting the error message:

XML parsing: line 7, character 411, illegal name character

just because I have characters like &, <, > in the data of the XML values....

Excellent Eugene Elutin,

Thanks very much!

Actually yes I had a typo :s

I have created the following XQUERY and seems to work well.. Any further suggestions maybe I can enhance the query?

SELECT DISTINCT

T.ID AS...

Hi Scott,

The method you presented is to change measure group values (numeric values). In my case I need to input String comments, possibly using Dimension Writeback..

Do you try this before?

Cheers,

Jon

Well by definition, the EXISTING keyword is used when you need a set to be constrained by the expression’s context. I've been struck by lightning, answering the question myself, you...

Chris,

Yes that is exactly what I meant! Yes so if another dimension comes into play the default member will be applied to the mdx query behind the scenes, and if...

That is great suggestion Chris. Would actually need to try that out but am quite confident that it will work well.

One last thing, if you have a query with User...

Hi Chris,

Unfortunately I cannot test the nested Except as I do not have access to the system at the moment, so it was more like a shot in the dark,...

Hi Chris,

Thanks for your valuable insights and for your time writing this excellent post.

You are spot on on what I was looking for and how you suggested in creating...