Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: disgustipated
- Order by date
-
Controlling Aggregations on Calculated Members
Hi, I've got an issue with my cube. I'm trying to perform a calculation using a calculated member, but when the totals are calculated, the value isn't the sum of the above. eg, In Column E in the below table, I'd like to see 24 rather than 22.75. Analysis server seems to do the same...- disgustipated
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Summing over time
Hi all, Wondering if someone can throw me a quick tip re: Analysis Server. I have a Dimension called {Periods]. Its heirarcy is:- [Year] --> [Month] --> [Week] What I want to do is sum a calculated measure for the entire year, regardless of what level the user is at, but I can't for...- disgustipated
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
OLAP Cube - Not showing Blank Rows
Hi All, Done some searching before posting this, but not sure if I've got the terminology correct. I have an OLAP cube that shows staff productivity information for a paritcular month, year etc. If a staff member is terminated, they are still showing in the report. Is it possible to...- disgustipated
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
