Here’s the question. I’m wondering if LLBLGen Pro will choke on an MDX query. If I only specify two dimensions, the result set looks just a SQL query. Except, I know Code Gen looks at the database schema, and I’d guess it knows nothing about SSAS cubes.
Here’s a simple query against that I am trying to do for consumption cube on a SQL 2005 Analysis Services. If you don’t mind, could you tell me if I could create a TSQL like so using LLBLGen
SELECT { [Time Dim].[Hour of Day] } ON COLUMNS, { [Measures].[Consumption Value] } ON ROWS FROM [ZSDW Consumption] WHERE ( [Time Dim].[By Week].[2007].[10].[3].[9].[15] )
