Your problem data:

"Column 'device_key' in Table 'Device' contains a duplicate value '1234567879' "

A key that you are using as the "one" in a "many to one" relationship has duplicate values...

quinn.jay (10/28/2016)

---

PB_BI (10/28/2016)

---

You can turn on the Olap Query Log (https://technet.microsoft.com/en-us/library/cc917676.aspx) and let that run for a week...

There's your problem. Remedy this and you won't have an issue. 😉

There are a few ways in which...

Okay well be warned, as...

ps_vbdev (10/20/2016)

---

I have the classic FactOrderLine table at the lowest granularity of items on orders. I have built this in my cube and when i connect with excel to get...

It was just a standard date table, examples of which you can find all...

GA_SQL (10/18/2016)

---

I got some idea how the InMemory analytics with cube works, such as it executes in the RAM instead of Hard disk, so it is very fast, to get...

Great article. I hadn't really thought about the practical uses for this new feature beyond some sort of audit trail. This has opened my eyes to the possibilities.

Cheers 🙂

quinn.jay (10/14/2016)

---

Hello,

I Remote to a Windows 12 Server, that has SQL Server 2014 install, Visual 2013, SSDT, and Attunity 3.0 for Teradata. I'm new to this existing platform where there...

Stylez (10/14/2016)

---

Good Morning Guys,

I would like to ask as I am trying to create a cover page for my SSRS report using Visual Studio 2015 and for some strange reason...

The following should help you:

https://www.mssqltips.com/sqlservertip/2932/using-the-ssis-wmi-task-to-gather-system-information/

Just output the values you need (free space, total space) to variables, have a third variable which calculates percentage left and then use precedent constraints...

The same way as before, deploy one with a report.

I don't think you can go back. You'd have...

BlackRabbit (10/13/2016)

---

BlackRabbit (10/11/2016)

---

The user used PowerBI to build and view reports, but the file size limitation became a problem, now they want an alternative solution that will give them the...

Well as per the last link I...

richardmgreen1 (10/12/2016)

---

Hi all

We're migrating to Chrome from IE but we've come across a couple of issues when using SSRS reports.

In some semblance of order:-

When you want to enter a date,...