SSAS

870

Solutions

759

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

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…

327 views
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

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 Databa…

131 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 the…

250 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 mont…

1437 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 usi…

1425 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 'SUM(…

1228 views

Experts,

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 s…

358 views

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 d…

256 views

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…

464 views

I loaded SQL Server 2014 for Developers and I see the following services running:

SSIS
SSAS
SSRS

How do I connect to them? In other words, I guess I need an IDE or interface. I am trying to le…

665 views
Course: From Zero to Hero with Nodejs & MongoDB

Interested in Node.js, but don't know where to start or how to learn it properly? Confused about how the MEAN stack pieces of MongoDB, Expressjs, Angularjs, and Nodejs fit together? Or how it's even possible to run JavaScript outside of the browser?

I noticed that SQL Server 2014 Developers Edition does not have SSDT or BIDS. However, you get a separate download of SSDT via this link:
                     http://www.microsoft.com/en-us/download/…

456 views

Below is the query I need assistance with:

(CODE)

150 views

I am new to SSAS and am working on learning the application. I have a Windows 10 machine that runs SQL exclusively in another part of the office. I do my development on another Windows 10 machine. It …

362 views

Hello Experts

Scenario

You take take an objective multiple choice test with options a)  b) or c)

A MS Word report will be written depending on your answers.

To illustrate:

Question 1
If Responde…

143,983 views

I like to study more about data flow, data warehousing and BIs.

How does big data come in?

Which are the technologies and solutions used by big companies for these?

Thanks.

13528 views

Hi

I have inherited an Excel 2003 spreadsheet that links to a SQL cube.  This works fine when run on XP but when run on Windows 7 the following error occurs

Invalid Class String

and then

Errors in…

51,831 views

I'm considering to go into BI analytics - also looking at Microsoft BI certification - is this recommended? http://www.microsoft.com/learning/en/us/mcse-sql-business-intelligence.aspx

Will MS SQL 201…

10201 views

I am attempting to setup a tabular model on my analysis server. I have followed the directions to a key and whenever I add a 2nd table, the queries slow down....really slow. I have created the relatio…

5256 views

i've just started creating a load of dimension tables with a Colleague at work.
we have approached it in two different ways.

i've just right clicked the table - edit and manually entered the attribut…

5333 views
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Dear all
I created my Cube using SQL Server 2012.
I want to create my dashboard using Excel 2013.
The idea is I have two pivot tables that I want to link together.
How can I do that?
Later I will crea…

6789 views

How could the Key column be included in a DMX query under the Mining Model Prediction tab?

The model used, say DT (for Decision Trees), can list every input and/or predict column except for the Key c…

2387 views

Hi,

We have requirement from client to calculate age group on fly.  Is not like calculated member from Data source view.

i.e. User drag measures and dimension agegroup (in this case calculate agegro…

9228 views

Hello,

I search a script for create admin user in analysis services with powershell.

Thanks

6902 views

Dear all
I did build my CUBE using VS2008
I want to format Datetime in Dimension from “01-01-2010 00:00:000” to be “01-01-2010”.
How can I do this in the CUBE

2185 views

Due to a very tight (TINY!) start-up budget, I’m looking at various options that will allow clients to view dashboards and reports from a webpage.

I’m currently using a SQL Server 2012 database to st…

2559 views
Show more content
201506-LO-Top-001

RELATED TOPICS view all topics

  1. MS SQL Server
    (156,092)
  2. MS SQL Server 2008
    (48,426)
  3. MS SQL Server 2005
    (71,399)
  4. Databases
    (53,341)
  5. SSRS
    (8,619)
  6. SSIS
    (1,534)
  7. DB Reporting Tools
    (7,992)
  8. MS Development-Other
    (47,910)
  9. MS Excel
    (127,850)
  10. .NET Programming
    (131,282)