|
AS2005: Trying to Use More Memory
|
| |
Environment: -- Quad-dual 64-bit processors -- 32 GB RAM -- AS2005 Enterprise x64, SP2 -- Windows 2003 Enterprise x64, XP3 -- 3 cubes each with 22 very large partitions and approx 7 dimensions per cube. (Each cube partition is built from an underlying fact table with 1B to 3B rows.) Problem: -- Running PerfMon, the system is ALWAYS paging (14K - 18K pages/sec).... more »
|
|
|
New to Analysis Service
|
| |
Hi all, I am new to Analysis Services. Where should I start: resources, web sites, books... Thanks. Han.
|
|
|
Using the asssembly Microsoft.AnalysisServices.XML A in a web application
|
| |
Hi I am currently looking into developing a web application which gives "power users" access to manipulating the properties on Cube roles. In theory, I want to be able to offer the same possibilities as one has in Management Studio e.g. "Cell data", "Members". However, the primary need is having the ability to add/delete an AD user to a cube role.... more »
|
|
|
Cannot create database - SSAS 2005
|
| |
Hi.. I am running SSAS 2005 on Windows Vista. My user account is in the Admin group for the laptop as well as in the SystemAdmin group in SQL 2005. I can create databases in the database engine...but when I try to create a new database in SSAS, I get the error: Either the user does not have permission to create a new object in... more »
|
|
|
Help with MDX Order by
|
| |
I want to order my mdx query by the most current dates volume. I am a newbie to MDX but very profficient in SQL so bear with me. This is the un-ordered query I have so far. This was an auto built query from reporting services, but looks how i want it except for the ordering. SELECT NON EMPTY... more »
|
|
|
Int's sorting as char's
|
| |
I have ContractID in my dimension - but it sorts it as a character not an integer: This is what it's doing: 7998 7999 8 8049 8890 9 9122 9733
|
|
|
Fact Tables like Partitions in 2005
|
| |
Hi All - In MSAS 2000 it was possible to have each partition point to a different fact table - not to meet the need now being met by mulitple measure groups but just for data management and some security settings. I am struggling with how to emulate this in the MSAS 2005. I want to have monthly fact tables - Oct 2008, Nov 2008 and Dec 2008 all of them... more »
|
|
|
Incorrect Grand Total value
|
| |
Hi, I have my first cube with two measure groups and some dimensions. I can process it without any problems but when it goes to using it, some data looks very strange to me. When I get data divided by members of one dimension (Product) grand total shows me exact sum of all members like here: productA 100... more »
|
|
|
Parallel Hierarchies in MS Analysis Server 2008
|
| |
Hello, I am new to Microsoft Analysis Server 2008 (and new to Analysis Services in General) and I am facing the following problem. I want to add a dimension to my OLAP Cube (in SQL Server Business Intelligence Development Studio) based on the following table: ----- categories ----- Child , Parent X, A... more »
|
|
|
Analytical processing problem
|
| |
We collect TV viewership data to provide details of ‘who watched what’ to advertising agencies. A typical report would show the distribution of the number of people who watched a given advertisement. The report will be further sliced into channels, categories of viewers, etc. We were thinking of OLAP as the solution as it keeps the data pre-... more »
|
|
|
