SSAS

879

Solutions

766

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

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

313 views
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

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 (https://www.experts-…

1010 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 cu…

115 views

What is best to use on the back end of cube (from star schema) views or the tables?

224 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 use…

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

718 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?

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

529 views

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…

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

143 views
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

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…

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

11,423 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…

11,289 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(…

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

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

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

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

676 views

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

476 views
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Below is the query I need assistance with:

(CODE)

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

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

144,090 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.

13541 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,909 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…

10212 views
Show more content
201506-LO-Top-001
Top Experts In
SSAS
<
Monthly
>

No Top Experts for this time period. Answer questions to earn the title!

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server
    (156,654)
  2. MS SQL Server 2008
    (48,736)
  3. MS SQL Server 2005
    (71,484)
  4. Databases
    (53,488)
  5. SSRS
    (8,694)
  6. SSIS
    (1,605)
  7. DB Reporting Tools
    (8,005)
  8. MS Development-Other
    (47,925)
  9. MS Excel
    (128,567)
  10. .NET Programming
    (131,532)