how would you model this in a data warehouse: there are municipalities which are geographical areas, that exist in geographical hierarchies, such a province (i.e. state, e.g. Minnesota), region (e.g. MidWest). a performance evaluation is done on these municipalities, by calculating performance indicators such as "% of housing backlog...
Say I have a measure, foo, in a cube, and I have a reporting requirement that users want to see the following measures in a report: total foo total foo excluding instances where foo > 10 total foo excluding instances where foo > 30 What is the best way to handle this? In the past, I have added Named Calculations which return NULL if fo...
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? ...
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 ...
I'm trying to create an OLAP Cube in Project Server based on a snowflake schema. I'm doing this programatically on the OnCubeBuilt event. I'm not using anything strictly related to Project Server, only the classes in the Microsoft.AnalysisServices namespace, but I wanted to be clear about what I'm trying to implement. Has anyone worked w...
Hi all, Can someone explain to me how to use the cross product function in matlab? An example, I have the following image with 6 fixed points on the cube, how to find the two other points of the cube? ...
is it possible create a cube with rounded corners in WPF? I found many examples that easily create cubes with hard edges but none with rounded ones. One possible solution would be a pre-rendered object, but that's not easy and controls to be put on the sides must be transformed separately. ...
What is the simplest way to programatically create a GeometryModel3D cube in wpf? ...
Hi there, I am running a SSAS cube that stores facts of HTTP requests. The is a column "Time Taken" that stores the milliseconds a particular HTTP request took. Like... RequestID Time Taken -------------------------- 1 0 2 10 3 20 4 20 5 2000 I want to provide a report ...
When refreshing the cube using XMLA ( created from te script in Process command), under what type does the job run as ...
Hi, I wanted to use dimension properties on columns. So, in the mdx query, I dragged in those properties from the dimension "member properties". But, for some reason, the values for those properties are nulls only. However, if the dimension members are used on rows, they have legitimate values. Is there any other way, I can pull in th...
hello i create a cube and want on one side an texture. glEnable(GL_TEXTURE_2D); glBindTexture(GL_TEXTURE_2D, texture[0]); glTexParameteri(GL_TEXTURE_2D, GL_TEXTURE_MIN_FILTER, filterMode); glTexParameteri(GL_TEXTURE_2D, GL_TEXTURE_MAG_FILTER, filterMode); glBegin(GL_POLYGON); //Vorderseite glColor4f(1.0f,0.0f,...
An error has occurred during local report processing. An error has occured during report processing. Query execution failed for dataset 'DataSet_XXXXX' Server: The operation has been cancelled. What the William H Gates is going on here? I am trying to preview a report, that uses datasets which connect to ssas cubes, in the report de...
Parser: The query contains the XXXXXName parameter, which is not declared. (msmgdsrv) I have no idea why I keep getting this error. It occurs when I change the MDX in the query designer and trying OKing out of the query designer. The strange thing is that the parameter DOES exist, I can see it in the parameters section of the dataset d...
I am trying to build a calculated measure in SSAS that incorporates a dimension parameter. I have two facts: Members & Orders and one Dimension: Date. Members represents all the unique members on my site. Orders are related to members by a fact key representing a unique user. Orders also contains a key representing the vendor for an orde...
There is a special way of mapping a cube to a sphere described here: http://mathproofs.blogspot.com/2005/07/mapping-cube-to-sphere.html It is not your basic "normalize the point and you're done" approach and gives a much more evenly spaced mapping. I've tried to do the inverse of the mapping going from sphere coords to cube coords and ...
Is there a eazy way or c# class to get 12 triangles of a cube where, only (MIN,MAX) coordinates are known for the BoundingBox cube i want to use PrimitiveType.TriangleList for rendering face of cube but dont know how to get static indices array of 12 triangles which can be defined by , MIN ,MAX vertices of the cube . I am using C# w...
I have the following scenario. A cube created in SSAS 2008. I can connected to this cube via Excel. I can create an offline cube file. I can connect to this offline cube file. Now, say I want to email this excel file along with the cube file so that another user can view it. I run into the problem that the connection path the offline c...
Hello, I'm working with SQL Server Analysis Services for the first time and have the dilemma of working on a project in which users must be able to access SSAS Cubes (via a custom web dashboard) that live across different servers and domains, but without having access to the other server's SSAS database connection strings. So Organizati...
Hi there I am not sure if the title has the correct terms, I have a developer and am very new to cubes. I have a cube which has data associated to materials that are broken down into chemical compounds. For example a rock material has 10% of this chemical and 10% of that chemical, etc. Samples are taken daily and sample is a dimens...