MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Course Of The Month
6 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
SSAS
894
Solutions
1
Articles & Videos
812
Contributors
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.
Refine results
One of the developers here created this process in Oracle that ends up being a query that references 5 tables with joins. What I did was create an SSIS package to load the data into SQL tables. I then…
1443 views
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that with a PowerShell script.
074 views
hi experts
i am reading about Working with Data Source Views in sql server data tools
i do not understand, As the creation of a relationship can improve performance, do you have any examples?
…
442 views
Hello Experts Exchange
I am developing a Finance cube, I'm trying to mimic the same functionality as SAP BPC.
In Excel the users look at the data in the SAP BPC cube and can view and update the …
157 views
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.
…
1043 views
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 …
6120 views
hi experts
about Dimension table indexes
What is correct?
1. Clustered index on surrogate key column
or
2. Create a clustered business key index
864 views
hi experts
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 …
365 views
hi experts
i am reading about: real-time operational analytics
in https://msdn.microsoft.com
whats the mean: real-time operational analytics
160 views
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…
153 views
Enroll in May's Course of the Month
May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
Hello,
What is wrong with this?
BEGIN TRANSACTION
UPDATE tn
SET tn.[NC_HIST_POST_1] = SubQuery.[2015]
FROM PS_NC_BUDG_STG_UPL tn JOIN (
SELECT *
FROM (
SELECT ACCOUNT
,…
381 views
Hi All,
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 …
10112 views
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 …
153 views
What is best to use on the back end of cube (from star schema) views or the tables?
291 views
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 …
2049 views
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 …
755 views
Hi,
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?
663 views
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 …
579 views
Free Tool: ZipGrep
ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Experts,
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…
3105 views
Hello,
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 …
180 views
Experts,
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 …
2122 views
Hi Everyone,
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 …
12,406 views
Hi Everyone,
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:
(CODE)
this query is …
13,559 views
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:
WITH
MEMBER [Measures].[Prior Year MTD] AS …
11,568 views
201506-LO-Top-001
SSAS
894
Solutions
1
Articles & Videos
812
Contributors
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.
Top Experts In
SSAS
