1
Reg:Problem with SSAS
Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I [...]
Answer Question
| March 31, 2012 2:17 PM
SQL Server 2005, SQL Server 2008, SQL Server migration, SSAS, SSAS 2005
Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I [...]
Changing date fields in SQL Server Analysis Services
In SQL Server Analysis Services, can I change the date fields from (yyyy-mm-dd) to (dd-mm-yyyy) without turning the date field into varchar?
Answer Question
| July 22, 2009 6:08 PM
SQL Server Analysis Services, SSAS
In SQL Server Analysis Services, can I change the date fields from (yyyy-mm-dd) to (dd-mm-yyyy) without turning the date field into varchar?
How well does SSAS run under virtualization? Any special considerations?
How well does SSAS run under virtualization? Any special considerations?
Answer Question
| June 23, 2009 3:31 PM
Microsoft virtualization, Microsoft Virtualization Chat 5/14, SQL Server Virtualization, SSAS, SSAS Virtualization
How well does SSAS run under virtualization? Any special considerations?
Monitor SQL Server 2000 Analysis Services Cubes
I am working in a BI role and have some ancient AS2000 cubes that are used across the organisation. Only trouble is no-one is exactly sure who uses them daily. How can i monitor which cubes are being accessed by whom? Doesnt seem that profiler picks up AS transactions so im kinda stuck how to [...]
Answer Question
| March 26, 2009 12:08 AM
SQL Server 2000, SQL Server 2000 Analysis Services, SQL Server Analysis Services, SQL Server business intelligence, SSAS
I am working in a BI role and have some ancient AS2000 cubes that are used across the organisation. Only trouble is no-one is exactly sure who uses them daily. How can i monitor which cubes are being accessed by whom? Doesnt seem that profiler picks up AS transactions so im kinda stuck how to [...]
Transform Data task properties not opening.
In my analysis manager, data transformation packages, i open a package and try to open the properties of Transform Data task. Whenever i am trying to open the properties the analysis managergot hungs.l The properties not opening. I am using MS SQL server 2000.
Answer Question
| March 10, 2009 6:34 AM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task
In my analysis manager, data transformation packages, i open a package and try to open the properties of Transform Data task. Whenever i am trying to open the properties the analysis managergot hungs.l The properties not opening. I am using MS SQL server 2000.
How to enable a trace for SQL Server Analysis Services using T-SQL?
Hi I want to enable a trace on analysis services Filter only the errors and notifications log them in a table and send a mail. I am right now doing using sql profiler, but i dont want to do this using profiler as i have to log on the server continuously. I need to do [...]
Answer Question
| December 2, 2008 9:27 AM
SQL Profiler, SQL Server 2005, SQL Server 2005 Analysis Services, SQL Server administration, SQL Server Analysis Services, SSAS, SSAS 2005, T-SQL
Hi I want to enable a trace on analysis services Filter only the errors and notifications log them in a table and send a mail. I am right now doing using sql profiler, but i dont want to do this using profiler as i have to log on the server continuously. I need to do [...]
How to generate MDX query from cube?
hi, i am a new devy in SSAS world. I sucessfully created a cube. I am able to browse the cube. In the browse window i drag n drop the measure and dimensions to see a expected result set. I want to know where i can see the MDX query for the result set? Thanks.
Answer Question
| August 4, 2008 7:16 PM
MDX Query, SSAS
hi, i am a new devy in SSAS world. I sucessfully created a cube. I am able to browse the cube. In the browse window i drag n drop the measure and dimensions to see a expected result set. I want to know where i can see the MDX query for the result set? Thanks.
Help needed for date dimension which is not rolled up properly.
I’m new to SSAS and I have dim_date table. Which have DateKey which is int and primary key (Eg data 19010101, 19010102 etc.,), date which is datetime(eg: 1901-01-02 00:00:00Z), year – smallint(Eg: 1901), month -tinyint(Eg: 01), monthname -varchar(January), day -tinyint (Eg: 1), dayname – Varchar (Eg: Tuesday), quarter -int(Eg: 1) I build a dimension using [...]
Answer Question
| June 9, 2008 6:15 PM
Hierarchy data, SQL, SSAS
I’m new to SSAS and I have dim_date table. Which have DateKey which is int and primary key (Eg data 19010101, 19010102 etc.,), date which is datetime(eg: 1901-01-02 00:00:00Z), year – smallint(Eg: 1901), month -tinyint(Eg: 01), monthname -varchar(January), day -tinyint (Eg: 1), dayname – Varchar (Eg: Tuesday), quarter -int(Eg: 1) I build a dimension using [...]
Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?
Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?
Answer Question
| April 9, 2008 10:38 PM
SQL Server Analysis Services, SQL Server data warehousing/business intelligence, SSAS
Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?
Microsoft SSAS with Cognos Front End
Is there anyone out there that is working or has worked with a Microsoft back-end (SQL SVR 2005, SSIS, SSAS) and a Cognos front end ? What is your experience with this ?
Answer Question
| February 8, 2009 11:44 AM
Cognos, SQL Server, SSAS, SSIS
Is there anyone out there that is working or has worked with a Microsoft back-end (SQL SVR 2005, SSIS, SSAS) and a Cognos front end ? What is your experience with this ?
1





