Top "Business-intelligence" questions

Business intelligence(BI) refers to the process of analyzing an organization's business data, by various (often computer-aided) means, to assist in the organization's decision making.

What options do I have for creating OLAP cubes with Postgres and making it accessible via .net webservices/wcf?

We have a large POSTGRESQL transactional database (around 70 million rows in all), and have previously created a data warehouse from …

.net postgresql olap business-intelligence xmla
joining across multiple fact tables with a dimension in between

What's a good approach to data warehouse design if requested reports require summarized information about the same dimensions (and at …

sql-server data-warehouse business-intelligence dimension dimensional-modeling
Accessing reports in OBIEE from a Java Program

I am developing an Java application using Netbeans which will fetch reports from the BI server on OBIEE 10G and …

java business-intelligence oracle-adf obiee bi-publisher
How do I integrate TFS Source Control with Business Intelligence Studio?

I am running Visual Studio 2010 Ultimate -- which integrates with TFS source control. However, when I run SQL Server 2008 Business …

visual-studio ssis etl business-intelligence
Sql Server Services - Overview anyone?

In Short I am thoroughly confused by the array of SQL Server services available, and am having a hard time …

sql-server reporting-services reporting ssas business-intelligence
Are Surrogate Primary Keys needed on a Fact table in a Data Warehouse?

When I asked our DB designers why our Fact table do not have a PK, I was told that there …

database-design business-intelligence
How do I concatenate string in Pentaho spoon?

I am a newbie to Pentaho (installed today). I was able to do basic transformation in Spoon. Now I need …

business-intelligence pentaho kettle
Difference between hierarchy and levels

I have just started working on Mondrian. I am having a hard time understanding hierarchies and levels. What is Difference …

business-intelligence olap-cube mondrian
Microsoft business intelligence platform vs QlikView

I have no experience at all with QlikView, but I have read great reviews about it. According to Gartner Research …

business-intelligence powerpivot qlikview powerbi qliksense
Can we compare saiku with Pentaho Analyzer?

I'm currently in an internship and i have to create a whole BI application. I think i'll use pentaho, and …

business-intelligence pentaho saiku