Gmwmn,

You do not need to switch to an integer if the current structure for the date dimension is working.

Thanks for comments!!!

Thomas

Deepak

Yes, you can take 2 measures from different tables and perform aggregations on them. Measures are unique throughout the model, so on any table, you can reference the measure in...

Hi pietlinden,

Thanks for reading the article and you are right, DAX is hard.

Thomas

Great article! Looks like triggers in SLQ Server.

Thomas

Nice article and steps!!!

Get well soon, Ken!!!

Thomas

Yes, creating views can be used as sources to 'tables' in Analysis Services.

Thomas

Hey Sean,

Thanks for reading the article.

It really depends on the size of the data, but as much CPU and Memory as possible. Remember, this is an in-memory technology. Here is...

Yes, you can have separate Date dimensions/tables in a tabular model like you described. A later article will give this example along with a suggestion from Patrick LeBlanc on using...

Thanks for the comments. 

rsmart42717, I would need more information about the "loops" in data modeling in order to include in a future article.I understand the 3 dates in...

Yes, it is #4. It is the sum o the default measure.

Sean Peffer (12/19/2016)

---

As per the other comments it easier to maintain the SQL code than SSIS derivation task and probably better to push the load onto the SQL server.

I know...

fsamstag (12/15/2016)

---

As a training exercise to learn about the Advanced Options, I suppose this is useful. But wouldn't it have been a lot quicker and easier (especially for a much...

sql Sarah (12/15/2016)

---

I have a question about this. We have fields with the data type of NVARCHAR because there are special characters in them.

If you are converting...