Lynn Pettis (4/19/2014)

---

SQLRNNR (4/19/2014)

---

Lynn Pettis (4/19/2014)

---

Greg Edwards-268690 (4/19/2014)

---

I...

I particularly like the fact that the thread...

Steve Jones - SSC Editor (4/17/2014)

---

WayneS (4/16/2014)

---

Steve Jones - SSC Editor (4/16/2014)

---

OK, now I'll be keeping a better eye on y'all. For the first time in like 3 years I...

Are you processing all dimensions first, then fact table?

And what is the performance processing 1 store at a time?

Generally, we would partition by year.

Clustered index on Business Unit, which would...

See if this helps.

Skip down to the loading partitioned table.

Can you give a few more details of how the tables are partitioned?

And have you tried single threading this process?

We had a mix of parallel and single threading loading in...

WayneS (4/16/2014)

---

Steve Jones - SSC Editor (4/16/2014)

---

OK, now I'll be keeping a better eye on y'all. For the first time in like 3 years I have no trips scheduled and...

cook155 (4/16/2014)

---

Hey Greg

So i did what you said. I went to the main security tab in SSMS and found the MSSQLOLAP and gave it adventure works dbo creator and reader...

This is something that they could document a bit better for the newbie.

The error kind of points in the general direction, but it's not exactly clear.

Probably more confusing by the...

SSMS.

It is just that the account SSAS is running under as...

Assuming SSAS and SQL are on the same server, the MSOLAP user was created on the machine at installation.

I usually verify that it exists under the under the main Security...

You might also see if you have an old copy of the original rdl to upgrade.

Many times I would start by making a copy of the whole project just so...

mah_j (4/13/2014)

---

Thank you for simplifying the calculation,so as he said if a server has 64 GB of RAM, and the Windows operating system is Windows Server 2008 64-bit Standard Edition,...

Just a side note - I come from an SSAS cube background.

So these end up as dimensions.

Simplifies doing this quite a bit.

Especially when you combine with other dimensions, as you...

Posting scripts for table structure and script for some sample data will get a better response.

In general, it sounds like if you have a where statement that grabs YTD info,...