EdVassie (5/21/2014)

---

We are also looking to redesign some of our schemas to make them more...

Thanks for the feedback.

Right now, I'm dealing with an OLAP database that will grow to about 1 TB per year. This goes up or down depending on business growth and...

Greg Edwards-268690 (4/7/2014)

---

One of the better reasons to crunch numbers in your process is that the logic is consistent.

Nothing worse than someone from above asks a question, and then gets...

Greg Edwards-268690 (4/7/2014)

---

We ran a 50 GB cube, 500 + measures, and over 300 dimensions, on a 32 GB server.

Largest fact table was 25M + records, but as you can...

Yeah, I saw with 2012. Currently on 2008 R2.

Koen Verbeeck (4/7/2014)

---

xsevensinzx (4/7/2014)

---

Depends. If you don't have much experience...

Greg Edwards-268690 (4/7/2014)

---

Koen Verbeeck (4/7/2014)

---

Any reason you are not using SSAS for this?

Aggregate fact tables can be useful, but make sure you are not creating a new table for every...

Thanks...

I'm pretty new to the BI game, so bear with me.

We are currently transitioning to SSAS/SSRS from a reporting module built on top of MS Access that exports data to...

Aww man, I missed the beta. I would have loved to have tried it. Please let me know if there is more. I'm designing a pretty large BI solution and...

I have a similar situation as you. My employer is running all importation and exportation (reporting) through MS Access. However, we have developed a very complex module that was built...

I'm a programmer at heart. I THOUGHT I learned SQL in a few days. I thought I was the master of SQL and that databases were easy to manage. I...

I would like to know too.

In my system, I have the effective ETL load date that is used instead. That's only because if the source effective date is unknown, then...

Very true Nadrek.

I worked in game development for 7+ years. It was always critical to have QA involved in the reviews. Maybe not every tester, but leadership present is valuable....

Thanks!...