Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.
Hello Experts Exchange
I'm new to SSAS cube development.
I have data for cost centres that are going into my cube, please see file attached.
I want to create a SSAS Hierarchy with the data.
We want to uninstall AD from a Windows 2008 R2 but we want to know what could be affected.
1.-After uninstall is created a new administrator account or we can login with actual administration …
about Dimension table indexes
What is correct?
1. Clustered index on surrogate key column
2. Create a clustered business key index
i have this question:
1. The cube of analysis services is physical or logical (it is constructed from the dimensional database)
2. Can an SSIS package load data into a dimensional …
i am reading about: real-time operational analytics
whats the mean: real-time operational analytics
I'm building a Cube. I can process, deploy and also I can connect through Excel and slice and dice.
It is working good for me.
But, after I ask user to test the cube, It is trying to gets the data…
How to find who has been connected to the SSAS cube?
What is wrong with this?
SET tn.[NC_HIST_POST_1] = SubQuery.
FROM PS_NC_BUDG_STG_UPL tn JOIN (
One of our SQL 2000 servers (running on Windows 2003) is running low on space. A couple of months ago I truncated the logs with assistance from experts-exchange link …
I have a non-additive measure in my fact table. In the measure's properties, I set AggregateFunction = None.
I processed the cube, and went to the Browser. I made sure to re-connect to the …
What is best to use on the back end of cube (from star schema) views or the tables?
Hi, I have created SSAS cube from my Data source View which is calling a view from my Database. I am now trying to deploy the Cube on local but getting permissions issue . It says login failed for …
Hi, we currently have 10 columns in a View in our sql server 2008 Database. Now, we need to build a SSAS cube to connect to this View and bring those 10 columns as it is straight. No changes needs to …
Is anyone knows that two instance ( Tabular and Multi-Dimension) that can install a single server? if so, is there any limitation this will be deprecated beyond 2014?
Hi, we have recently moved to new production servers and we have back end sql server 2008r2 Datawarehouse in a datazone. we have sql sever VIEWS in our datawarehouse which Users connect to them using …
I'm looking for input on ideas to keep in mind when planning and creating a MEDICAID data warehouse. This data will be used to help identify WASTE, FRAUD AND ABUSE.
Has anyone worked on…
I have a SSAS Tabular Cube that has been moved from one server to an new one and was wondering about the permissions needed on the new server to connect to the SQL Server that has the …
I have 2 separate Cubes (Cube 1 and Cube 2) that reside within the same SSAS Database. They share only a few Dimensions.
I need assistance in a Plan to "Separate" these 2 cubes into …
I am kind of new to MDX so this is most likely a simple question. I am trying to build a calculated measure that is filtered by a dimension. I want to have my total sales for each …
I am working on a MDX based SSRS report. I am bit of a novice in MDX and SSRS so i am hoping this is just a simple fix. I have the following MDX query:
this query is …
I am new to SSAS, and am trying to add a new calculation to my cube to get change % and I am trying to avoid divide by zero in the following MDX:
MEMBER [Measures].[Prior Year MTD] AS …
I have a client that created 2 separate Cubes using the same SSAS Database...
Can someone please share with me a brief listing of the PROS (if any) and CONS of having 2 separate Cubes …
I need some direction in possible help regarding slow queries times when we are using ROLAP Cube with TERADATA backend.
We do NOT have the option of AJI at this time. We currently do not have the …
Currently we have SQL Server 2012 Standard which hosts our corporate DB. We would like to allow our analysts to connect to this data using Power BI.
We have been able setup Power BI to connect to…