Hi Vijay,

there has been a lot of things that I have learnt since I wrote that ODS article and last year I wrote a data warehousing book, http://www.amazon.co.uk/dp/1590599314/...

Hi, try scripting the AS database on the old AS server to XMLA then run the XMLA script on the new AS Server to create the AS DB.

Change the...

Thank you Tom, it was insightful and useful.

Kind regards,

Vincent

Hi Peter and sgivoni,

yes you are right, the answer is not accurate and I apologise for that.

The correct answer should have been, as you said, in Reporting Services Project in...

Thanks for explaining it Steve. So when you restore Sales.abf to sales, SSMS said "Unable to read from the transport connection: An existing connection was forcible closed by the remote...

Hi Steve,

there is no security that you need to setup when restoring sales.abf or when opening the analysis services project. When and where did the "access denied" error happen?

I'm...

Hi Steve, I just reposted the sales_abf.zip, which seems to be successful this time.

Try downloading it. Then on step 3.4 (restore database window on SSMS) restore it as different database...

Reposting the attachment... (sales_abf.zip)

Hi all, thanks for all your responses.

Debbie, I attached sales.abf in zip format. I hope you would be able to restore the multidimensional database from this file into your SSAS...

Hi Ed,

the word "not" was meant to be there.

3 of the answers are usually used to improve DW performance (summary tables, partitioning and index), whilst 1 is not (backup).

Kind...

Thank you for sharing your experience about ODS with us Cliff.

With regards to the SCD beyond the 3 types Margy Ross and Ralph Kimball describe several alternatives and combination...

Hi Danie, possible causes if the relational query is different from the cube are:

1. Named Query in the Data Source View

2. Measure properties such as AggregateFunction and MeasureExpression

3. Dimension...

Hi Jonathon, as mentioned on KB 931975, the DST issue still happens in SQL 2005, i.e. today (4th Nov) at 2 am the scheduled jobs were not running for 1...

Dear all, thank you for all your responses.

Jonathon Prosper: I'm not sure how datetimeoffset is stored Jonathon, but I'm guessing that 6-8 bytes are used to store the date and...

Thank you for sharing your real project experiences with us Jamie. 

They are especially valuable as you are one of the most expert person in SSIS.

Vincent