Hi ,
I have created a new data warehouse which has a dimension table User with all the user details like username, userid, FirstName,lastname,DOB, gender, Age etc .. and have measure groups lik...
http://www.experts-exchange.com/Database/OLAP/Q_23537517.html
Hi,
My cube processed fine on my desktop but when I tried to process the dimension of the cubes on the VM its taking ages the VM behaviour is completely different . the dimension processing is st...
http://www.experts-exchange.com/Database/OLAP/Q_23546182.html
Zones:
OLAPDate Answered: 07/09/2008 Grade: B Views: 4
I would like to create an account dimension in SSAS in which I have a simple hierarchy where some of the members are subtracted rather than added. For example Operating Income = Gross Margin - Expe...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21788913.html
Hi,
I have a SQL Agent job which fires an SSIS package. The package contains 2 tasks which process an AS2005 database. Each cube/dimension is set to process in its own transaction. The server...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2348...
I have a cube with 3 fact tables (Outpt Services, Hosp Services, Crisis Services) and several dimension tables. All 3 fact tables directly relate to each dimension table. When testing in Visual S...
http://www.experts-exchange.com/Database/OLAP/Q_23480680.html
Hi,
I am new to datawarehousing and was trying my first real cube.
I have two databases on the same server and hence I have created two DS on SSAS 2005 one of the DS has fact table and many dim...
http://www.experts-exchange.com/Database/OLAP/Q_23510973.html
I am using this MDX script in one of my reports but it takes 80 seconds to execute. I am new to MDX scripts. Can you please let me know how I can optimize the script so that execution time can be r...
http://www.experts-exchange.com/Database/OLAP/Q_23747328.html
I have scheduled SSAS database backup using the utility, msmdarch, in SQL Server 2000. I now have a 2005 SSAS installation on which I need to schedule backup. I can't seem to find any info on msm...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2292...
how to save a XMLA query result and parth them in a table .
http://www.experts-exchange.com/Database/MySQL/Q_23732538.html
Zones:
MySQL ServerDate Answered: 09/19/2008 Grade: C Views: 0
Hi,
I am browsing the cube in SSAS 2005. I want to see the MDX query generated by the filter criteria i have selected. How can i view the MDX query in SSAS - which was generated ?
Appreciate ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2305...
