paul s-306273 (1/4/2012)

---

In my experience all sales staff over exaggerate the merits of the software that they are trying to sell you. Only the non-IT people are easily duped. Unfortunately...

would it be possible to combine the 4 dimensions in the DSV and then create 1 "super" cube-dimension for use in the dm model?

removed

I think you could just create a new "cube dimension" based on the FactCampaign table. In the dimension usage tab, the association to the FactCustomer table would be a...

awu (12/20/2011)

---

Can I just do:

3. copy all SSAS databases from old box to new box;

4. restore all SSAS onto new box;

5. point the connections to old box ( or they...

What are you trying to accomplish with the where-clause? It looks like you are trying to filter the cube for only data where the value in [Work Item].[Microsoft_VSTS_Common_Priority_String].[2 -...

samyuktha.vallabhaneni (12/19/2011)

---

iPolvo (12/19/2011)

---

will the updates, deletes, inserts only involve recent...

Not sure what your time/date dimension looks like, but assuming you have a User Hierarchy called [Calendar Hierarchy] and you have designated it as a "time" dimension...you can use the...

darth_vodka (12/2/2011)

---

hi

a simple question (yes i've tried googling, no luck!)

i want to silo my cube between three network groups

North - who can only see North data

South - who can only...

will the updates, deletes, inserts only involve recent data? ...

mnDBA (12/10/2011)

---

Let me preface this by saying I am production support DBA. SSAS is not my area of expertise, at all. So forgive me if I butcher some terminology...

awu (12/16/2011)

---

We are running performance issues these days, and decide to purchase a new box and separate SSAS with SQL Server 2008 instance, so, question is how to...

roles & security

calculated measures (i typically include a copy of the MDXScript as well)

Also, you may find this interesting...

http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/

No, I don't think automatic MOLAP will meet your latency requirements of 5-10 minutes. With automatic molap, the server never switches to real-time OLAP, and queries may be stale...

do you mind posting the query that was being called? I'm curious to see what part of the cube was being processed. I ran into a similar issue...