business-intelligence

online business intelligence

We want to deliver reports with over 600,000 rows. we use asp to create a report, but it times out and truncates the report. can u make a suggesion as to prevent the report from timing out. ...

What is free-ware (or just cheaper) analog to Tableau (ad-hoc BI)?

I need an ability to connect to different sources (minimum MS SQL and Excel) and EASILY create ad-hoq reports, on the fly. What is the solution for this, apart from Tableau (http://www.tableausoftware.com/)? Thanks in advance. ...

MS Reporting 2010: Use Multi-Value Drop-Down to Add/Subtract WHERE clause from SQL Query

I am currently trying to create a report in Visual Studio 2005 for MSSQL 2005. I need to provide a multi-valued drop-down box that would allow a user to select one or more options. If a user selects one or more of these options, my SQL statement would need to add a AND column = 'something' to my SQL query. I am wondering how I might acc...

Serialized data in a MySql Database to use in a Business Intelligence tool

Hi, I have a database (MySql) and need to store some results from a web service monthly. The data can have 10 results today but may have 200 next month. I need to use a BI tool to create charts and what not. Someone proposed to serialize the data and save the blobs in the database, while the solution seems to work, I have a gut feel...

Business Intelligence (BI) on Wikipedia data

Intro: I am a BI addict and would like to develop a project to drill-down Wikipedia's data. I would write scripts to extract data from dbpedia (probably beginning by people articles) and load it into a people table. My question is: Has anyone done this before? Even better, is there a community dedicated to this? If it the scripts are so...

Business Intelligence for small and medium scale companies

Hello gurus, I would like to know if i can get a case study for my dissertation with the above topic. I am in dire need of data I can use for the developing the data warehouse and that would help me arrive at a possible conclusion of using the BI application I would be developing.Many thanks for your audience. Regards, Tunde ...

How to create BIRT report based on multiple data sets

I need help in creating a BIRT report; the situation is that I have multiple queries but the report all columns should be grouped by One column for example (Operator) Like : Operator | Expr1 | Expr2 | Expr3 | Expr4 | op1 | ## | ## | ## | ## | op2 | ## | ## | ## | ## | op3 | ## | ## | ## ...

Meaning of Business Intelligence

The word "Intelligence" has two meanings: 1: the ability to learn, apply knowledge, or think abstractly. 2: a: information concerning an enemy or organization or group with the task of gathering such information. b: news or information of any kind. In the term Business Intelligence, which one is the meaning of Intelligence? 1 or 2? A...

Is my path of learning data mining correct

Someone has just told my boss what data mining can do to a company like recommendation , predictive modelling. Basically we are a website company. I am going on leave for 6 months. So my boss said that I can learn some DM techniques so that when I come back we can visit small shops or small companies to provide them with predictive data ...

What should I have in mind when building OLAP solution from scratch?

I'm working for a company running a software product based on a MS SQL database server, and through the years I have developed 20-30 quite advanced reports in PHP, taking data directly from the database. This has been very successful, and people are happy with it. But it has some drawbacks: For new changes, it can be quite development...

Is this a proper idea of BI workflow ?

Hi all, I am new to Business Intelligence. I just got hired by a company in order to complete their websolution, implementing a BI Module. After lot of reading, I think I could get an idea of what a BI Process looks like, you'll find enclose my idea of a BI process. Can you please tell me if this is a correct vision of the all workflo...

What database Palo OLAP server handles ?

Hi all, I was wondering what Palo OLAP Server handles as input Database ? Does someone know where I can find a list of the input Database supported ? Thank you ! ...

From where to learn the basics of Sql Server 2005

I am new to SQL Server 2005 and want to start from the basics with examples. Could anyone guide me how can I proceed. As my target is to learn Businness Intelligence[BI], what I need to concentrate to get the sufficient knowledge to walk into BI? ...

Two or more similar counts on fact table in dimensional modelling

I have designed a fact table that stores the facts for a specific date dimension and an action type such as create, update or cancelled. The facts can be create and cancelled only once, but update many times. myfact --------------- date_key location_key action_type_key This will allow me to get a count for all the updates done, all t...

How to deploy an existing PerformancePoint dashboard to a new site?

Hi, Apologies if the question is not worded appropriately. I've created a dashboard using the dashboard designer and succesfully deployed it to our development server. Now I'd like to deploy it to our staging server - is there a way to do that? I've tried pointing the designer at a different URL without success. Thanks, Phil ...

Reporting Services: Strange Behaviour with hidden rows

When building a report in Business Intelligence Studio 2008, I've noticed that the hide/show details indicators default to a plus sign [+] if the row(s) are set to display when the report is initially run. Then, clicking the control causes it to change to a minus sign [-] when the rows are hidden. This is backwards from what I would expe...

What are some BI tools that integrate well with Sharepoint 2007?

We currently use MOSS 2007 for our company intranet site and we are looking to create dashboards for performance kpi's etc. Weve been using SSRS 2005, Cognos as well as excel services and BDC. I've demoed Dundas Dashboard as it comes with a sharepoint web part for viewing dashboards in SharePoint. Are there any other BI platforms out the...

Palo Suite 3.1, Ubuntu, missing OLAP Server

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 ? ...

Using MDX, how to get only a few selected rows?

I have a Color dimension with many colors, but I want to show a table with just two rows (black and red). I tried this: SELECT [Color].[black] || [Color].[red] ON ROWS, {[Measures].defaultMember} ON COLUMNS from [SalesAnalysis] The result I was expecting was a table with one column and two rows. One cell for black sales, one cell f...

In MDX, calculate the sales rank of a given shop

I have an OLAP cube containing the sales count for each of my shops. Using MDX, how can I output the rank of a given shop? I am dreaming about something like below (does not work), it would return 8 if SomeShop is the 8th most-selling shop: SELECT RANK( [Shop].CHILDREN, [Shop].[SomeShop]) from [Sales] ...