ssas_开发者

MDX Query to return list of customers except customers from previous time periods

I have a trouble writing 2 MDX queries: 1) A query that should return all customers (with corresponding sales amount), which have made a purchase in the last 3 finished months (at least 1 purchase in[详细]

2023-04-12 14:46 分类：问答

SSAS 2008 R2 - Datasource with an DNS Alias not working

I have an SQL Server with SQL Server Engine and SQL Server Analysis Services (2008 R2). The physical name of the server is SQ21. For beeing flexible we created a dns alias (Host A) which points to thi[详细]

2023-04-12 14:20 分类：问答

MDX Query to Produce Revenue by Top N Advertiser

I need to create a report using SSRS 2008 that will show the top 10 advertisers by revenue.I wrote the MDX query in management studio as follows:[详细]

2023-04-11 13:31 分类：问答

How to make my SSAS cube production ready

I am developing a data warehouse + a data cube for a certain client using Microsoft technologies (SSIS, SSAS and SSRS). I have almost finished doing the data warehouse. I have created a data cube in S[详细]

2023-04-09 05:46 分类：问答

Not able to make an HTTP access to SQL Server Analysis services 2008 on Windows Server 2008 via IIS 7

My intention is to access the SSAS Database without Windows authentication. The user outside the domain should be able to access the cube and built PIVOT tables around it. Thus I found that we can use[详细]

2023-04-08 17:42 分类：问答

Dimensional Level Security / Per User Data Security in SSAS Cube?

I\'m part of a team looking to move from our relational data warehouse to a SSAS cube.With our current setup we have an \"EmployeeCache\" table (basically a fact) which is a mapping from each of our e[详细]

2023-04-08 00:11 分类：问答

Setting up a relative dimension?

I have a pretty simple scenario but a very large data set (using even simpler example below to illustrate my issue).[详细]

2023-04-08 00:04 分类：问答

to OLAP or not to OLAP

I want to ask what are the performance gains of pulling reports in Sharepoint 2010 directly from an Oracle DW using an ODBC Connection as opposed to building an OLAP Layer using SSAS and accessing th开[详细]

2023-04-07 20:41 分类：问答