Hello!

I've been working with BI/DW since 1999. Most of this time with SQL Server (since version 7 beta and Olap Services).

I want to thank the author for this kind...

May not be practical.

May not be standard.

But it is a good/smart solution.

🙂

Regards.

Hi.

Congratulations!

I was thinking about how was the look of the site in the beginning.

I found at http://web.archive.org.

http://web.archive.org/web/*/http://www.sqlservercentral.com

It's good to see the evolution.

Congratulations again.:)

Regards.

Hello.

Maybe other guys here could help you better than me. What comes to my mind right now is the Microsoft Project Real and the Data Lifecycle documentation produced by that...

Hello.

ReportPortal.

http://www.reportportal.com

Hope this help.

Hi.

Usefull links (for me).

DataWarehouse (by DMReview)

(Spend some time inwhite papers)

http://www.datawarehouse.com/

Microsoft - MSDN - Best Pratices in BI and DW

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_analservbp.asp

Directory of Datawarehouse.

http://www.infogoal.com/dmc/dmcdwh.htm

DW Infocenter (by...

Hello.

You may install PivotTable Services (ptsfull.exe or ptslite.exe).

Look for "Redistributing Components" in Books Online. There is an interesting topic named "Setup Parameters and Silent Installation".

Hope this help.

Hi.

MDX Sample Application is demo software that comes with Analysis Services.

Start/Programs/Microsoft SQL Server/Analysis Services/MDX Sample Application

1 - Start the Sample Application

2 - Connect with your Analysis Services Server

3 - Query...

Hello.

Are you able to query the cube with MDX Sample Application?

It seems that you have some corrupted data.

Regards.

Hello.

I don't know if Excel XP uses "AddCalculatedMembers" while querying the cube.

Try to build a report in excel and save as web page adding interactivity (to use Office Web Components).

Check...

Hello Vincent.

When you say "Data is ok within cube browser" it means that you can see through Browse Data (in Analysis Manager) these 4 calculated members and its respective values...

Enjoy as much as I can a day with my wife.

Also, I play my 1986 Fender Precision Bass at home or with friends. I don't play very well but I'm...

Hello.

I guess this because the XMLData Property of the PivotTable keeps the cube information (before process). I don't know how to turn around this specific problem. Maybe a script saving...

Hello.

What is the frequency of data change (inserts, deletions and updates) of the tables involved in this query? If it is not so frequent, You may try create a table...

Hi.

To help you get the MDX.

Inside the PivotTable's connectionstring insert the following: "Query Log=C:\MDX.log;". You can write this file to any other drive or folder, and change the name if...