We've worked hard to work up a full dimensional database model of our problem, and now it's time to start coding. Our previous projects have used hand-crafted queries constructed by string manipulation. Is there any best/standard practice for interfacing between python and a complex database layout? I've briefly evaluated SQLAlchemy, S...
Actually i'm using R + python with RPY2 to manipulate data and ggplot to create beautiful graphics.. i have some data in postgresql database, and i'm using psycopg2 to querying data. I'm starting thesis, and in the future i need OLAP cube to store my (very big) simulation data : multiple dimension, aggregation query, etc. Is there any ...
I need an example of what drill up/down is ( + if it's graphical ) for a better understanding of these operations. I'm new to the whole Data Warehouse subject so high level explanations would be appreciated. ...
I am currently importing two measure groups from two different cubes in a single new cube. There is a measure with the same name in the two cubes, when I import the measures in the new cube I get an error during cube processing because of the duplicate ID. How can I avoid this? I am using AMO to build the cube pro grammatically. (SQL Ser...
Are there any driver available for JOLAP or Olap4j to access existing OLAP services? I think on OLAP services like Oracle, MS SQL, etc. We want start a OLAP project with Java? With which of the both API should we start? ...
In one local financial institution I was rebuked by their programmers for expressing them my opinion that (their programmers' obsession with) (b)locking issues in their MS SQL Server 2005 OLAP (SSAS) database(s) did not make much sense to me. (The OLTP databases are SQL Server, Oracle and non-RDBMS ERP). What are locking issues in OL...
With astonishment observe that: 1) that no answer to question Transactional And Reporting Databases - How? mentions SSAS databases from MS BI (Business Intelligence) platform: SSAS (SQL Server Analysis Services) databases (OLAP, datawarehouses, datamarts) + DM (DataMining). SSRS - SQL Server Reporting Services SSIS - SS Integration S ...
I'm trying to provide some default sorting within the OLAPDataGrid component in Flex. There appears to be a dataCompareFunction on OLAPAttribute, but nothing I do seems to actually trigger calls to that method. Any suggestions around using this method or any others to provide sorting of the dimensions on OLAPDataGrid? ...
In my OLTP database I have a layout consisting of instructors and students. Each student can be a student of any number of instructors. A student can also sign up for an instructor, but not necessarily book any tuition (lesson). In a data warehouse, how best would this be modelled? If I create a dimension table for Lessons, Instructors ...
I want to display String Data in OLAPDatagrid, but it seems that OLAPDatagrid can only display the numerical data. When a set the dataprovider with string values, it doesn't display. Does anyone have some ideas how to do it ? Thanks ...
Hi all, I just installed Palo Suite 3.1 with the archive I got form the official web site. I am running Ubuntu 10.04. Once installed and logged in I got the surprise to do not have the "OLAP Server" menu. Does anyone know if there is something extra to do ? ...
Am making a cube in SQL Server Analysis Services 2005 and have a question about many to many relationships. I have a many to many relationship between two entities that contains an additional descriptive column as part of the relationship. I understand that I may need to a bridge table to model the relationship but I am not sure where...
I was trying to find a tool to increase performance in the reports of our application and I heard about OLAP + Reporting Services which is described as an excellent combination to do this work. Anyway I didn't find the way to keep the OLAP cube up-to-date since the data in the original DB can change. (It's a transactional application and...
Hello guys! Would someone advise me technology for accessing Infobright from java, or some technics... things of that nature.. as far as I understand I should use plain jdbc connection and execute queries... not making use of high level thing like hibernate... Am I right? Thanks in advance! ...
I have a very simple MDX query that retuns the contents of a dimension. I would like to inject one more row to the result set as part of the MDX. Is this possible? ...
Dear StackOverflow gurus, I have the following scenario: From .NET (v3.5, c#) I connect to an OLAP Cube using the Microsoft.AnalysisServices namespace and objects in order to manage dinamycally the translations of dimensions, measures, attributes,etc. A sample code updating an attribute caption translation looks like this: foreach (D...
I'm struggling to find an efficient and flexible representation for my data. We have a many-to-many relationship between two entities which have arbitrary lifetimes. Let's call these Voter and Candidate. Each relationship has a measurement which we'd like to summarize in various ways. These are timestamped and are guaranteed to be within...
We have a large POSTGRESQL transactional database (around 70 million rows in all), and have previously created a data warehouse from this (updated daily) to run reports off of. To make this more flexible (as lots of different users require different reports and aren't very good at specifying what they want) we would like to create a mul...
I've a relational table (id, parentId, name) which I'd like to convert to a flattened dimentional table (id, Level1, Level2, Level3, Level4) I'm ok fixing the depth at 4 deep. I've made progress with a recursive CTE and pivot, but the result set isn't right I get Id Name Level1 Level2 0 Root NULL NULL 1 NULL L1 NUL...