I'm looking for a control that I can put on top of an already existing OLAP star schema to allow the user to define their own "queries" and generate reports. Right now I have some predefined reports built on top of the cubes, but I'd like to allow the user to define their own criteria based on the cubes that I've created. I've found lo...
Hi everyone! I've been studying the paper condensed cube: the effective approach to reduce the cube size and i have a question, does the min-cube or bu-bst cube store the data by using array? or they store it using tree? Thanks everyone :) ...
I have a cube with several dimensions. I need (a measure, calculation, whatever...) to show last value of a column, assuming the table is sorted by another column. Something like: SELECT TOP 1 column_1 FROM table_1 WHERE «The user's selected dimentions will work as a filter» ORDER BY column_2 DESC ...
I have a problem with creating an offline OLAP cube from C# using following code: using (var connection = new OleDbConnection()) { connection.ConnectionString = "Provider=MSOLAP; Initial Catalog=[OCWCube]; Data Source=C:\\temp\\test.cub; CreateCube=CREATE CUBE [OCWCube] ( DIMENSION [NAME], LEVEL [Wszystkie] TYPE ALL, ...
I'm trying to push data into an OLAPCube in flex. The data coming in is flat and nothing else is known before hand. How do I have flex automatically create dimensions and such so that I can bind something to the cube? Using a flex chart, it's as simple as setting the data provider to an array collection and it works. The ONLY exampl...
I have an application that requires analytics for different level of aggregation, and that's the OLAP workload. I want to update my database pretty frequently as well. e.g., here is what my update looks like (schema looks like: time, dest, source ip, browser -> visits) (15:00-1-2-2010, www.stackoverflow.com, 128.19.1.1, safari) --> 10...
I have built a cube in visual studio and deployed to SSAS. How can I get the data refreshed using a nightly sql batch job or some other means? TIA ...
I'm evaluating tfs2010 and i'm actually in stuck with mdx rdl reporting. Where i could find some example about iteration query? (Sprint team capacity for example... ) ...
I'm relatively new to MDX and am trying to accomplish what I think should be an easy thing, but I haven't found any solution. I have a sales cube and one of the measure is profit which can be negative or positive. I want to get one measure which is effectively the sum of positive profit, i.e. only include in the new measure those profit...
I'm currently researching SQL Server 2008 as a business intelligence solution, and currently looking at Analysis Services (and I'm pretty new to business intelligence as a whole...) I'm a bit confused by some of the terms in SSAS, particularly the conceptual differences between cubes and MS's Unified Dimensional Model. I believe tha...
In Business Intelligence Developer Studio, I'm wondering why one would want to create a report model from an OLAP cube. As far as I understand it, OLAP cubes and report models are both business-oriented views of underlying structures (usually relational databases) that may not mean much to a business user. The cube is a multidimensio...
I've been developing an application that talks directly to an SSAS 2005 OLAP cube. Note that I also have SQL Server 2008 installed, so the other day I did a Windows Update and decided to include SQL Server 2008 SP1 in my update. After doing that, my SSAS 2005 cube is no longer accessible from my application. I'm able to browse the data ...
Hello, I'm new to MDX and have a problem regarding filtering out values from a summation. We want to perform normalization calculations, specifically a quantity (q) divided by a basis (b) to get an Intensity (I). The formula is fairly simple I=q/b. OUR CUBE STRUCTURE: We have fact tables FactQuantity and FactBasis, each of which are ...
So I'm basically brand new to the concept of BI, and I've inherited an existing ETL process that is a two step process: Loads the data into a database that is only used by the cube processing Starts off the SSAS cube processing against said database It seems pretty well isolated, but occasionally (once a week, sometimes twice) it wi...
Hi, On my SSAS 2008 instance if a backup/restore of any database is made to/from a UNC path I get an error : The following system error occurred from a call to GetOverlappedResult for Physical file: '\server\share\OLAPDB.abf', Logical file: '' : Insufficient system resources exist to complete the requested service. . Server: The operat...
I am a newcomer to data warehouses and have what I hope is an easy question about building a star schema: If I have a fact table where a fact record naturally has a one-to-many relationship with a single dimension, how can a star schema be modeled to support this? For example: Fact Table: Point of Sale entry (the measurement is Dollar...
I have this mdx query: SELECT NON EMPTY Hierarchize({DrillDownLevel({[Date].[Date].[All]})}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ,[Date].[Date].[Date].[Month] ,[Date].[Date].[Date].[Week] ON COLUMNS ,NON EMPTY Hierarchize({DrillDownLevel({[Work Item].[System_AssignedTo].[All]})}) DIMENSION PROPERT...
Hi, I have a mesurement which is an average and it mapped as a CalculatedMember to support aggregate tables: <Measure name="AverageFullPercent_sum" column="fullDockPercent" datatype="Numeric" aggregator="sum" visible="false"> </Measure> <Measure name="AverageFullPercent_count" column="fullDockPercent" datatype="Numeric" aggregator="coun...
Is there any command or tool that can recreate the schema and fill the needed time data into the time dimension SQL Table for deployment reason? I'm currently facing the issue that only during designing the time dimension SQL Table the wizard is populating the table, afterwards there seems to be no way to invoke the same process again....
I am trying wrap my head around how data is being served to Project Server. I am trying match up a value (actual cost) to project lines in an Executive View of Project Center which displays each project. This actual cost comes from another database; the accounting database. I am assuming I have to build it in an OLAP Cube. Anyways, I...