You can get SQL 2014 Developer Edition for free from Visual Studio Dev Essentials (https://www.visualstudio.com/products/visual-studio-dev-essentials-vs?wt.mc_id=WW_CE_BD_OO_SCL_TW_DESQLBenefitAnnouncement_SQL)

That has SSIS and everything else. Just don't use it for production or Microsoft will break...

The same process applies to both matrices and tables in SSRS.

https://msdn.microsoft.com/en-gb/library/ms170712.aspx

Okay, so assuming your facts don't...

imani_technology (4/27/2016)

---

Good idea, but we have new data going into Hadoop/Hive every 10 minutes or so. Are you saying we should use SSIS every 10 minutes or so as...

imani_technology (4/27/2016)

---

We tried using Multidimensional against our Hadoop/Hive data. It didn't work. The problem was linked server, which made performance unacceptably slow. That's why we are using Tabular....

imani_technology (4/26/2016)

---

The back-end data is a single Hive record set. That record set includes columns that were joined within Hive from Hive tables that I don't have access to....

m.f. (4/26/2016)

---

The ValueColumn was not set before.

The datatype of my [Column_A] in the tabular model is from type date.

The ValueColumn from my Dimensionattribut [DateTest] now references to this [Column_A] in...

m.f. (4/26/2016)

---

hello, thank you for the reply.

I have changed the ValueColumn to a Column from the DSV which is from datatype date.

The dimension-type is Time.

The KeyColumn is a Intenger, the...

You need to set the Value column of your Date attribute to use a date column from your relational source - beware this could have consequenses. You also need to...

Hi Alan,

Usually an error like this is due to a change in the underlying structure not being propagated through the entire cube design. For example if you have a measure...

adamfewtrell (4/21/2016)

---

I understand your suggestion regarding columns. We got round this one-off testing problem by borrowing a server with 128GB of memory.

However, I was really trying to understand the...

mcopa (4/15/2016)

---

I got a request from someone today and need some assistance. They need to connect to an SSAS instance in someone's domain. They only have SSMS loaded...

imani_technology (4/14/2016)

---

I'm using SSAS 2014 Multidimensional. I have a date dimension table that has dates going to about 01/01/2018. However, when I browse the cube using SSMS or...

This normally happens when one of the existing accounts in the security group has a problem with it, e.g. it no longer exists. Check the other accounts and make sure...