Many thanks for the reply.

Need one more suggestion.

As per current requirment Issue can be logged at

1. asset level

2. applicaiton level

3. process level

4. line of business level

5....

Many thanks for the replies

Even i am interested to have status and priority as dimensions, but does it have any impact on ETL layer.

Also the status and priority table would...

In the above model dimension_issue and fact_issue is have 0ne to One relationship; Is it correct to have this kind of model?

We do have a reqirement to design a OLAP model for consolidating the issues identified on ASSETS from various sources\system.

Let us take one sample record;

Issue | Asset | Status |Priority...

set @xml =

" '

'"

@xml_with_new_namespace

" '

'"

Was cracking my head for a while..Thanks a lot john.