More effective Set to Sum function? Summary:
MEMBER Measures.CustTotal AS Sum({.[Customer ... {CustTotal, [Internet Sales Amount]} ... FROM [Adventure Works]; ...
MSAS/SQL Server 2K on VMWare Summary:
My company has decided to put our environment of MSAS/SQL Server 2K on ... One application in particular which has been in production for a ... Could VMWare be causing these issues? ... getting pretty much all of the CPU & memory that is available, ...
OWC and AS 2005 Cube Drillthrough action Summary:
I setup drillthrough action on AdventureWorks sample cube, ... to view drillthrough through cube browser. ... Does anyone get drillthrough working on AS 2005 cube in OWC 11? ...
Adding Hints to the SQL for processing cubes? Summary:
an SQL query gets run - I can see that query ... I have a nightly process ... I would fix it by adding the hint OPTION(MAXDOP ...
newbie question re many-to-many fact modelling Summary:
Show all rooms by timeslot - being used or not? ... Show all rooms by timeslot - number of attendees? ... Show all presenters by timeslot - number of attendees? ... ShowId,RoomId,TimeSlotId and NumberofAttendees and another that has ...
XmlaError: Server: The operation has been cancelled. Summary:
XmlaError: Server: The operation has been cancelled. ... When looking at the trace info, ... TextData: Server: The operation has been cancelled.. ...
Analysis Services 2005 Browers Seems Slow Summary:
so I apologize in advance... ... I have a fact table with about 1.3M rows and three dimension tables (one of ... I ran the Design Aggregation Wizard, ... partition with 70 aggregations. ...
HELP I am about to quit on AS2005 Summary:
dimentions with sufficient control is lacking and and bound to end in a dead ... SQL server manager managegement studio and MDX for data access. ... Visual studio 2005 to define the AS2005 side of my model. ...
calculation the median Summary:
I'd like to calculate the Median within a cube in SQL Server 2005. ... I have a duration and the number of occurances --> so it was not ...
Newbie MDX Question - How do I "freeze" or lock a value? Summary:
In order to do some of my calculations (turnover), ... I need that same headcount to be used ... change because employees are added or subtracted as the year goes on. ...