I'm running MOSS 2007 with SSRS 2008, and I'm encountering an issue with an SSAS-backed report that has four parameters, all of which are attributes on the same dimension. When I run the report from MOSS, it works just fine. When I change the parameters from the default values to specific values, the report still runs fine. When I try...
I'm trying to create a cube where the total is taken from an attribute on the fact and not calculated as an aggregate of the children in SSAS 2005. For example Assume I have 10 stores which all had 100 customers visit on a particular day. There was however some overlap where some customer visited multiple stores. The total visitors f...
I have built a cube that contains ticket sales information. I have a measure that is a distinct count of customer numbers from the fact table. The unsold tickets for each performance are recorded in the fact table and are assigned a "special" customer number that refers to a dummy customer record. I would like to have the distinct coun...
Hi all, I've got a cube (cube A) which is linked into another cube (cube B). Now I'm trying to add a new measure to cube A, so it can be used in cube B. Sadly that doesn't work. I'm receiving error messages that there's something wrong with the metadata when adding the measure. I also tried to modify the cube via an XMLA alter statement...
Hi, I'm in a position of evaluating products / approaches to build Business Intelligence Dashboards on top of Sharepoint WSS (no MOSS at this stage). Does anyone have any suggestions where would be a good place to start? The BI platform is currently built on SQL Server 2005 / SSIS / SSRS and we're currently investigating adding SSAS to...
I am trying to match existing reporting functionality while building up a new cube for a Proof of Concept. Can I retrieve data from my cube using an MDX query and put it into a recordset so I can then populate an Excel Sheet with the data? ...
Hi, I'm new to cubes and MDX and have been struggling with this problem for a while now. My fact table has the following columns (Start and End contain dates and times down to the minute level): ID (int) Start (DateTime) End (DateTime), plus other dimensions. I've created a table called DimDateTime that has a sequence of 15 minute i...
I have the following query that gives me an extract (I am putting this into a CSV from my cube). I want to show the Total of all NRx in a column as the first column NRx and the rest of the NRx columns should come up as they do now. I tried to add a SUM (Measures.NRx) to this, but it did not work How do I get a total NRx column? SELECT...
Hi As I am new to SSAS,have been reading an article on Multi-Dimention OLAP Cube and struggling to understand Cube concepts, It has been said that Although the term "cube" suggests three dimensions, a cube can have up to 64 dimensions. Could you please explain how is this possible on cube (other than 3-Dim example x,y,z planes)? Please...
I have the following query that gives me an extract (I am putting this into a CSV from my cube). I want to show the Total of all NRx in a column as the first column NRx and the rest of the NRx columns should come up as they do now. I tried to add a SUM (Measures.NRx) to this, but it did not work How do I get a Total NRx column? SELECT...
In a parent-child dimension in SSAS, the datamember is automatically named the same as the parent. E.g. Division X Risk Register Division X Risk Register Department A Risk Register Department B Risk Register Division Y Risk Register Division Y Risk Register Department P Risk Register Department Q Risk Register I want all the da...
Proficient with SQL but new to MDX, I am having trouble getting my head around this: I have a fact table that contains snapshots of account balances monthly. I need to roll up the balances as a semi-additive measure - straight sum doesn't work, obviously, for balances. However, I DO need to sum all the balances within EACH month, separa...
I have a table with a list of contract line items in the form of CREATE TABLE contracts_lines ( contract_id integer, product_id integer, contract_line_start datetime, contract_line_end datetime, amount float ) What I would like to produce is a VIEW (or populate a table) that allows me to determine how much revenue I can expe...
I need a template to document an SSAS cube. Cube info Single source of data One main Fact table Five direct dimensions Two many-to-many dimensions 48 Partitions, 48 Aggregations Can anyone point me to design templates for SSAS cubes? ...
These are really hard to describe without going in-depth into the data structure, i'll try to keep it as short as possible while giving as much info as I can. I have a measure which is a monetary value over time (cashflow), along with dimensions for date, and one for valuation. A valuation has a date, and this date would correspond with...
Hi, I am a novice in SSAS with some theoretical knowledge in it. I would like to do the very first and the simplest of all implementation in that. I searched in google but the one's I found are a bit high enough for me to grasp. Could you please suggest me some good links/articles(Step by Step [ would be better if diagrams are given])...
Hi, I have a many-to-many dimension in my cube (next to other regular dimensions). When I want to exclude fact rows in my row count measure, I usually do something like the following in MDX SELECT [Measures].[Row Count] on 0 FROM cube WHERE ([dimension].[attribute].Children - [dimension].[attribute].&[value]) This might seem more com...
Below is the snippet of an mdx query used in a report. with member [Measures].[Leased Coin In] ([Machine Dimension].[Leased Flag].&1 , [Measures].[Coin In]) Now, my question is: In the cube under Machine Dimension, there is no attribute hierarchy name called Leased Flag. I looked at in the xmla script, there is no such name. But, the ...
Is there a way to calculate the MODE in SSAS? I see there are Microsoft provided functions for Median, AVG, Max, and Min but nothing for Mode. Would I need to code a user defined function in .net to make this happen or is there an easier alternative? ...
We have an SSAS server with a cube deployed on a server over the WAN.. We are trying to connect to the cube from Excel on various client workstations. The server is not on a domain with the clients. It "works" for some of us but not for others. We are trying and failing yet to determine what the difference is on the machines that wor...