I'm new to MDX and trying to solve the following problem. Investigated calculated members, subselects, scope statements, etc but can't quite get it to do what I want. Let's say I'm trying to come up with the MDX equivalent to the following SQL query: SELECT SUM(netMarketValue) net, SUM(CASE WHEN netMarketValue > 0 THEN netMarketV...
Is it true that Analysis Services ONLY supports windows authentication? ...
Im trying to deploy as Analysis Services database using an ASSL script. I can create the script using "script as" in management studio. But I can't find out how to run this script? ...
Is this possible? It seems when I try and do this manually or via an SSIS task it does not work whereas it will be fines with other editions. (I'm using my local developer edition as a test environment) ...
Hi, I am stuck with something really nasty here. I have a SSAS Cube that was working fine till day before yesterday. Had some performance issues on the server and got cummulative patch 938077 on top of Service Pack2. Since then I have not been able to deploy the cube - with a strange error - File System Error: The following error occu...
Hi, I have a fact table that holds all date & time attributes as keys which links to actual DATE & TIME dimension. When I create a cube on top of it using SSAS 2005, these datetime attributes are split into individual dimensions for the CUBE, which is OK. Problem is when I add a new datetime attribute to the fact table, my cube doesn't ...
I have a structure like this in a DB | RoleID | RoleTypeID | PersonID | OrganizationID | FromDate | ToDate | Each role is only valid for dates between FromDate and ToDate. Each person has a name, gender and birth date. I want to put this date into a data warehouse to use with SSAS. There I want to be able to build cubes with the nu...
I have an organization table and an organization membership table Org table: |OrgId|Name|...| Org membership table: |MembershipId|Parent organization id|Child organization id| This describes an org structure where one organization can be a child of several parent organizations, the parent organizations may in their turn be children of...
I get exception: 0x800414154 (REGDB_E_CLASSNOTREG) while attempting to browse any deployed cubes through SQL Management Studio. I read it had something to do with Microsoft.Jet.OLEDB 4.0 but wasn't sure how to solve the problem. Thanks ...
I have a dataset in Reporting Services that looks something like this: ID | Type | Name -----+--------+-------- 1 | A | Mary 2 | A | Joe 3 | D | Steve 12 | F | Irving I want to show a textbox IF AND ONLY IF there exists a row where type = A. Basically, I want to do "Fields!Type.Contains("A...
In Short I am thoroughly confused by the array of SQL Server services available, and am having a hard time finding a brief primer. The Scoop I am a long time ASP.Net developer who has happily been churning out ASP.Net applications for years. These have usually been based on SQL server and a range of custom tables and views. Just re...
I'm trying to learn SSAS on my own and am having troubles understanding a problem with my cube. I have a database project where I want to do reporting on a single table. I know this a bit unusual, but its a relatively simple model and data has already been normalized into that one table. It has two columns that serve as dimensions- ti...
This post from SqlBatman describes a situation similar to my current client and, in reality, indicative of many companies that rely on tons of reports which have been shifted to over-night processing because of their performance impact. How do I get started using Analysis Services in general and OLAP Cubes in particular to help my clie...
Hi, I am trying to implement security in SSAS 2005 cube. I have had my share of success so far, am able to create a role and apply the ALLOWED and DENIED sets to members I wanted to apply security on. Now starts the problem - If I browse within the Analysis Services and select the role the security works as intended. But when I login a...
People don't seem to be able to get the data from the cube unless unless I set the database permission to "full control" on the server. What is the right way to give read access (only) to a cube in Microsoft SQL Server Analysis Server ...
I have a Database that contains data about articles,structures and manufacturers. Meaning an article is linked to 1 manufacturer and to N structure-nodes (think as article-classification-nodes). Querying articles using T-SQL with a lot of conditions is currently too slow to be usable for an e-shop, even with good hardware and properly i...
I have been tasked with getting a asp.net (vb.net) talking to an analysis services engine on our production servers. The web server is a separate machine from the web server. The web server runs as the IUSR_ user. The application (of course) works on the development machine which has both IIS and Analysis services on it. The problem I se...
I am trying to import a KPI from Analysis Services into a PerformancePoint Scorecard, and when I do, The Dashboard Designer throws an error: An unknown error has occurred. If the problem persists contact an administrator. There may be additional information in the server application event log. When I examine the event log, ...
Group, We built a data cube using SSAS and are now building SSRS reports off of that cube. Not sure if anyone has come across this, but when you build the report using the wizard and include parameters all looks fine. However if you are in the report after the wizard is compete, and you decide you want to remove one of the parameters y...
I'm trying to form an MDX query such that it returns only the combinations of two dimensions where a measure meets a certain criteria. I thought this would be pretty straight forward using the FILTER function, i.e. SELECT NON EMPTY FILTER({[Program].[ByRegion].[Program] * [Performance Metric].[Metric].CHILDREN }, [Measures].[Point...