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 strongm 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: mikelblanco
- Order by date
-
SQL Analysis Server Aggregation Calculation Problem
Hi MDXer First of all, thanks for your reply, I was getting desperate. I'm not sure I f I understand your words but it seems that I'm doing it the hard way. I can rebuild the cubes, that would not be a problem. Which way you think would be the easiest one? What do you mean by "having control"...- mikelblanco
- Post #3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
SQL Analysis Server Aggregation Calculation Problem
Hi I have a calculation problem in my cubes: My goal is to calculate the cost of each individual sale by multiplying the quantity times the cost, and then to have the sum of these individual calculations to have a sum of all costs. This is the setting: I have a virtual cube (V) taking two...- mikelblanco
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Join 2 Cubes
Hey John, great help man,now I can sleep. Cheers bro- mikelblanco
- Post #3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Join 2 Cubes
Hi ALL I'm running out of brain cells so please help me. I have two cubes with two different measures in each: Cube A has measure salesprice and Cube B has measure cost, both of them have ITEMID dimension. I want to have both measures in same cube AND sorted by ITEMID. I created a virtual cube...- mikelblanco
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
