Hello All, I'm having an issue with an Analysis Services project in Visual Studio 2005. My project always builds but only occasionally deploys. No errors are reported and VS just hangs. This is my first Analysis Services project so I am hoping that there is something obvious that I am just missing. Here is the situation I have a cub...
I am trying to find a good way of accessing a Business Intelligence OLAP Cube from C#. I don't really care much as to how this is done, but since currently I am trying to implement this with the codeplex WPF Toolkit, I would be happy if it was something directly related to the tool, but any suggestions are very welcomed. My WPF skills ...
Hi, I am new to MDX and I know that this must be a simple question but I haven't been able to find an answer. I am modeling a a questionnaire that has questions and answers. What I am trying to achieve is to find out the number of people who gave specific answers to questions., e.g. the number of males aged between 20-25 When I run t...
Is there an ORM-analogue for querying OLAP cubes / data-warehouses? I'm specifically interested in the .NET world, but generally interested in anything ;-) ...
Im trying to deploy as Analysis Services database using an ASSL script. I can create the script using "script as" in management studio. But I can't find out how to run this script? ...
I have a system that involves numerous related tables. Think of a standard category/product/order/customer/orderitem scenario. Some tables are self referencing (like Categories). None of the tables are particularly large (around 100k rows with an estimated scale to around 1 million rows). There are a lot of dimensions to this data I ...
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'm working on a reporting system that allows the user to arbitrarily query a set of fact tables, constraining on multiple dimension tables for each fact table. I've written a query-builder class that automatically assembles all the correct joins and subqueries based on the constraint parameters, and everything works as designed. But, I...
I'm trying to learn SSAS on my own and am having troubles understanding a problem with my cube. I have a database project where I want to do reporting on a single table. I know this a bit unusual, but its a relatively simple model and data has already been normalized into that one table. It has two columns that serve as dimensions- ti...
This post from SqlBatman describes a situation similar to my current client and, in reality, indicative of many companies that rely on tons of reports which have been shifted to over-night processing because of their performance impact. How do I get started using Analysis Services in general and OLAP Cubes in particular to help my clie...
Hi I need to build a local .cub file for my Excel-using clients. I have scrounged together some VB code but it fails : ConnLocation = "LOCATION=C:\test.cub;" ConnDSN = "SOURCE_DSN=DSN=TEST;UID=test;PWD=pass;" ConnCreateCube = _ "CREATECUBE=CREATE CUBE [TestCube] (" & _ "DIMENSION [account_code]);" Connection = CreateObject("ADODB.Con...
People don't seem to be able to get the data from the cube unless unless I set the database permission to "full control" on the server. What is the right way to give read access (only) to a cube in Microsoft SQL Server Analysis Server ...
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...
Hi I'm a little confused on how to connect BI with data mining. Can BI be termed as some kind of a manifestation of data mining? How different is a BI tool like Microsoft Analysis Services from a data mining tool like Weka? I guess BI involves more of reporting and analysis of data, where in the data undergoes some kind of aggregatio...
I built an MDX query, to retrieve specific articles from an OLAP Cube. Basically it returns articles below a specific article-category node that are produced by a specific manufacturer: SELECT NON EMPTY ( Hierarchize ( { DrilldownLevel ( { [T DAT Article].[Ar ID].[All] } ) } ) ) DIMENSION PROPERTIES PAR...
I am a newbie to ORACLE. I would like to access an OLAP cube in Oracle using C#. Could you please suggest efficient ways of doing the same? ...
I'm attemping to update an Excel 2007 pivot table in VSTO (C#) and would like to ensure that the pivot table doesn't get updated until all of my edits are done. So there's a property on the PivotTable class, ManualUpdate, that apparently does exactly what I want. Unfortunately it appears that often times when I assign it the value "tru...
Hi I am using Excel as the front end to a SQL Server Analysis Services (SSAS 2008) cube. I have a "calendar" dimension, which consists of a hierarchy of year-quarter-period where period is a 4 or 5 week month. Excel offers lots of useful options under its "Date Filters" menu such as being able to select just Quarter 1 etc. This works ...
I need to get a dimension member returned as a calculated measure. Given: Dimensions Customer {ACME, EMCA, Universal Imports, Universal Exports} Salesperson {Bob, Fred, Mary, Joe} Credit Type {Director, Manager} Measures Credited Value Value Relationships The Customer is a dimension of the facts that contain Value The Custome...
We currently have our custom application that is being distributed with our database (SQL 2005/2008). It is an easy task, before we release a new version we just pack our database into SQL initialization scripts (these create tables and populate data). We use SQL Management studio to generate these scripts. As a next step we would like ...