So imagine that you need to create a solution to moving the aggregated data from a cube into another location for a third party, such as a spread sheet, SQL Server table, or a flat file. We can accomplish this task using SSIS. First, create a new OLE DB Connection using the Microsoft OLE DB Provider for Analysis Services 10.0 (or 9.0 if its an SSAS 2005 cube you need to get to). After creating our Connection Manager, we can now create a Data Flow Task with an OLE DB Source using our new Connecti...
Read More
This week's puzzle, Lucky Number Slevin , required you to use a couple function that we have yet to try out. So let's step through the solution to understand how I met the requirements of the puzzle: The first thing we need to do is create a calculated member that will figure the Gross Profit Per Unit. To do that we'll need to divide the Internet Gross Profit by the Internet Order Quantity. WITH MEMBER [Measures].[GrossProfitPerUnit] AS [Measures].[Internet Gross Profit] / [Measures].[Internet O...
It's that time again. This week's puzzle will be due by Thursday, January 13 so I can post the answer on the following Friday. Once again, congratulations to Srihari on winning last week's MDX puzzle and the really sweet t-shirt! Rows: States Products Columns: Internet Gross Profit Internet Order Quantity Gross Profit Per Unit Filters: None Hints: Show the 10 products by state with the lowest Gross Profit Per Unit where the Gross Profit Per Unit is greater than $500.00. The product name must con...