We have a client that has Oracle Standard, and a project that would be ten times easier addressed using OLAP. However, Oracle only supports OLAP in the Enterprise version. Migration to enterprise is not possible I'm thinking of doing some manual simulation of OLAP, creating relational tables to simulate the technology. Do you know of ...
Particularly, Does it work with 9i Standard? Do you have some easy example that'd allow me to check it? ...
Is there a simpler interface for end users to run "queries" on pre-existing SqlServer Analysis Service cubes? I'm looking for a way to deploy the cubes and allow the users to work with the data through a simpler interface than BIDS. Is this even possible? ...
Can anyone recommend a good resource -- book, website, article, etc -- to help me learn SQL Server Analysis services. I have no knowledge of this technology right now but I do constantly work with SQL server in the traditional sense. I want to learn about Cubes and Using Reporting Services with it. I want to start from the bottom but ...
I am trying to build an OLAP datasource from a bunch of binary files, and our current model just isn't working. We are using SSAS as our analysis / reporting model for our results, but aren't able to get the performance we want out of SQL. Our main constraints are: The database is very large. We have huge dimension tables with mil...
I've had SQL 2005 & 2008 CTP installed side-by-side with no problems. Recently uninstalled the CTP after it expired and now whenever I try to browse an analysis services cube in SSMS 2005 or VS 2005, I get the follwoing error: Retrieving the COM class factory for component with CLSID {C4F9B80B-89F7-4800-9C26-504D6E692B2C} failed due to...
I'm trying to create a cube with a single measure. This measure is a distinct count of a "name" column. The cube works perfectly if the measure is set to "count" type. However when I set distinct count I get this error: "Errors in the OLAP storage engine: The sort order specified for distinct count records is incorrect" I have read in ...
Hello all, is there a free set of controls to be used for representing the OLAP cubes in aspx pages? something like the ones from Dundas, but free and (if possible) cross-browser. Thanks, Lucian ...
The terms are used all over the place, and I don't know of crisp definitions. I'm pretty sure I know what a data mart is. And I've created reporting cubes with tools like Business Objects and Cognos. I've also had folks tell me that a datamart is more than just a collection of cubes. I've also had people tell me that a datamart is a ...
I know you can get metadata and schema info from relational stores in Microsoft SQL Server 2005+ via: INFORMATION_SCHEMA Object Catalog Views What is the equivalent of this in Microsoft Analysis Services? ...
I have what is to me a bit of a tricky design issue in my SSAS cube. The question is related to general accounting practices, I have a fact table containing financial transactions (i.e. a ledger) and each of those transactions is tagged with a transaction date and a period. The period does NOT related directly to a day, or a series of ...
I've got Dim Tables, Fact Tables, ETL and a cube. I'm now looking to make sure my cube only holds the previous 2 months worth of data. Should this be done by forcing my fact table to hold only 2 months of data and doing a "full process", or is there a way to trim outdated data from my cube? ...
So i just received a connection string to a Cube in our one of our SQL databases. I'm supposed to create a report that can be emailed to 30 something people off of this data. I would much rather write a stored procedure and just let SSRS send it out whenever its supposed to. The problem is that the database is extremely complex and I'm ...
I have been tasked with moving a cube which is in SQL 2000 to SQL 2005. It would appear that the Dimensions and Measures are all coming from one table. Is this possible in SQL 2005 or do I need to restructure the data into multiple Dim/Fact tables, and is there any way to easily move a SQL 2000 cube into SQL 2005? ...
We have a cube that we are populating the data from the source tables. To get the data to reflect we are calling the "Analysis services processing task" component. While the cube is being refreshed we are getting the following error. Description: OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01. End Error Error: 2...
There are Cognos PowerPlay Cubes (Cognos v7.3) which are distributed via Email and then stored on local clients. At the moment, users use MS Access as an interface to access the data and reports in the Cubes. Is there any other tool, application or programming language which allows to access the PowerPlay Cubes and the tables/graphs wit...
I know a bit about database internals. I've actually implemented a small, simple relational database engine before, using ISAM structures on disk and BTree indexes and all that sort of thing. It was fun, and very educational. I know that I'm much more cognizant about carefully designing database schemas and writing queries now that I kno...
I have a Database that contains data about articles,structures and manufacturers. Meaning an article is linked to 1 manufacturer and to N structure-nodes (think as article-classification-nodes). Querying articles using T-SQL with a lot of conditions is currently too slow to be usable for an e-shop, even with good hardware and properly i...
I have a cube with fact tables that have a parent-child relationship: Person - Case. Some dimensions are inferred from the parent, e.g. State in the example below. Person does not have a foreign key to the State dimension, but Case does, and through the Person-Case relationship the State is inferred. By doing it this way, I end up with ...
I'm creating a data mart in SQL Server 2008 using SSIS for load, and SSAS for an OLAP cube. So far, everything is working great. However, I haven't created any indexes on the source database other than the default clustering on primary key. I'm pretty comfortable with designing indexes on the application databases, but since this da...