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...
We are looking at swapping out a Dundas webform charting control to an OLAP chart control. The only reason for this is to make use of an OLAP data source. For those familiar with Dundas, can we use the web form charting control but just change the data source? ...
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...
In most cases, each level of a hierarchy within a dimension represents different concepts (i.e. country->region->city, year->month->day) and this is simple enough to use in a cube. What I'm interested in are variable depth hierarchies which tend to consist of instances of the same concept, i.e. nodes in a computer network where the "dep...
We'd like to create a simpler alternative to Excel's CUBEVALUE function for retrieving data from an OLAP server. The details aren't critical, but briefly, our function will "know" the source connection and accept a very simple ticker-like parameter and a date, in place of CUBEVALUE's MDX-style parameters. This is for internal use within ...
Hi All, I have a dimension with parent child hierarchy as shown in code block. The issue i am facing is if i have a filter on parent child dimension then drill through table does not show filtered data instead it shows all the data for that dimension. Here is an example. <Dimension type="StandardDimension" name="page_type_d" caption="P...
I have been looking into PowerPivot and concluded that for "self service BI" and ahoc buidling of cubes it has its uses. In particular I like the enhanced UI that you get from using PowerPivot rather than just using a PivotTable hooked up to an analysis services datasource. However it seems that hooking up PowerPivot to an existing anal...
I'm a complete newb to MDX / OLAP, "data warehousing" in general. I have the following MDX query and would like my results to display the month's number (1 = January, 12 = December). Luckily, the cube creator created a member property named "Month Number Of Year" When I try to run the query, I get the following... "Query (4, 8) The func...
I would like to be able to query against an SSAS2008 instance and get a listing of all the catalogs that exist in it, as well as their respective storage sizes. In Management Studio, I can right click on the catalog and go to its properties, which retrieves this data, so I know it exists somewhere. A query that has some of the informat...
I am building a poor man's data warehouse using a RDBMS. I have identified the key 'attributes' to be recorded as: sex (true/false) demographic classification (A, B, C etc) place of birth date of birth weight (recorded daily): The fact that is being recorded My requirements are to be able to run 'OLAP' queries that allow me to: 's...
Hi, I'm working on a Django project where I need to provide a lot of different visualizations on the same data (for example average of a value for each month, for each year / for a location, etc...). I have been using an OLAP database once in college, and I thought that it would fit my needs, but it appears that it is much too heavy fo...
Hello, Since the zohmg project seems to be dead (no new commits since nov 2009), I would like to know if any of you used/uses it (with successful results). Or if you know anything about future of this project. And if not, is there any alternative for this project. I'm looking for tool that will help to extract data from (apache) logs ...
I have cube in Microsoft Analysis Services with several dimensionsions and measures. When I(in cube browser, or through pivot tables in excel) try to drag dimension's attribute to grid with no measures added the following happens: if there were unknown member, then only it is displayed. Other rows from dimension are not displayed. if ...
Can We create such kind of reports using Crystal Reports XI Cross-Tab? Product Sales Comparison +---------------------------------------------------------------------------------+ | | Jan | Feb | Mar | April | May | TOTAL | | |---------------------------------------------------...
I'm still learning the ropes of OLAP, cubes, and SSAS, but I'm hitting a performance barrier and I'm not sure I understand what is happening. So I have a simple cube, which defines two simple dimensions (type and area), a third Time dimension hierarchy (goes Year->Quarter->Month->Day->Hour->10-Minute), and one measure (sum on a field c...
How the data access can be faster using OLAP ? ...
Here are the two designs I have : (I'm using SQL Server 2005) Constellation Schema : http://img84.imageshack.us/img84/7206/constellation.jpg Star Schema : http://img692.imageshack.us/img692/971/starme.jpg I need to build a report which shows ProjectID,ProjectName,Hours,isImpacted,isRequesting for a given line of business(LO...
Hello, I have a MDX query that needs to agg some data but filter on leaf nodes. I have a way to do it using DEPENDENTS and EXCEPT, but there can be 10's of thousands of leaf nodes, and filtering out is taking quite a bit of time SELECT { [Measures].[Field1], [Measures].[Field2], [Measures].[Field3], [Me...
Suppose I have a [Sales] cube which has a [Store] level and a store has a "type" property. Which query should I use for showing the sum of sales for all the stores of type "Supermarket"? (e.g. You sold 6M $ in all stores of type "Supermarket") ...