Thanks Nakul for comments.

Good point about when to use Data Conversion component.

Thanks for comments.

You can use the Data Conversion component and get the same results. My preference is changing the T-SQL and not use a Data Conversion component, but not for...

Yes, you need to partition the table for improvements to ETL (SSIS) and partition the Cube and only process updated partitions.

Whether by date or version does not matter. What ever...

Multidimensional is more mature right now. We have chosen it over tabular for 2 main reasons.

1. KPIs have a trend component (down side is it has to be written...

Simple, No

Thomas

Hey Steve,

Great series!!! Perfect for a morning reading to start the day.

Thanks,

Thomas

Good article. Would be a great part of a session on new features of 2016.

Thomas

Great description.

But, you need to give some examples and scripts and diagrams to make this a great article.

Now, you got me wanting to read the book, but I probably won't...

Great series. Thanks!!!

Thomas

I would re-deploy the cube from Visual Studio With Full Deploy and Process All Data.

Thomas

Sometimes that is the path to go on, easier ETL.

thomas

You are going to need an adequate amount of RAM and CPUs to run the reporting on this machine.

Read about Max Server Memory for you instance of data, then about...

For performance, this depends on the size of the related fact table and how many rows are going to be duplicated if the Fact table in the Bridge part contains...

I agree with HappyCat, place it in the view. This gives you (or a DBA) more flexibility in performance tuning the query in the view than a column added in...

Wayne,

Excellent job.

Thomas