FAQ Database Discussion Community


Assign Dimension value to SSIS variable

sql-server-2008,ssis,ssas,ssas-2008,data-cube
I have data cube hierarchy as follows. I can access the highlighted node as SELECT [Calendar].[Report Days].[All Members].[All].[WantInReport].[Yesterday].LastChild ON 0 I tried to run this query in Execute SQL task and assign the output to an SSIS variable. But issue is the column name is changing. I tried to alias...

Two sets specified in the function have different dimensionality

ssas,ssas-2008,ssas-2012
I have a basic query and having trouble understand exactly what this error means. Select {[Dim Date].[Date].[Date],[Measures].[Quantity]} on columns from [AcoEdsv] ...

How to delete default Measure Groups in the SSAS CUBE?

sql-server-2008,ssas,ssas-2008
I have created a CUBE. By default CUBE created few Measure Groups. When I go to Aggregations, I can see the default Measure Groups. I want to delete them all and want to create as per the requirement. Attached is the screenshot, ...

What cube deployment changes will force a reprocess?

ssas,cube,ssas-2008
Sometimes when I deploy a cube that has been changed (from BIDS), I can continue to browse the existing cube data. Other times, the engine insists I reprocess the data before I can browse the cube. I can't find a definitive resource showing which changes require a data reprocess and...

How to view the data from SSAS CUBE

sql-server-2008,ssas,ssas-2008
I am new to SQL Server CUBES. I have processed the CUBE in SQL Server 2008 environment. How to view the data based on its dimensions? Do the CUBE needs to be mapped to the Reports to view the data? Whether the CUBE has to be processed on daily basis...

MDX - Retrieving a level of members currently used in where clause

sql-server,ssas,mdx,ssas-2008,data-cube
I have a simple data cube with organization structure hierarchy defined. In my calculations inside the cube I would like to have different calculations depending on which level of organization items is currently used in WHERE clause in MDX query. So let's say that I have 5 levels of organization...