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
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
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:
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
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
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
I have a pretty simple scenario but a very large data set (using even simpler example below to illustrate my issue).
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开
I require help of the experts again! I have set up a drop down list to be a parameter of another dataset.
When I have two members references with the &[Value] syntax being crossjoined, then I get this error:
加载中,请稍侯......