Stack Overflow
Stack Overflow

Questions tagged [business-intelligence]

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. BI technologies are capable of handling large amount of unstructured data to help identify, develop and create strategic opportunities.

Business Intelligence explains the process that a system uses to gather raw data from different types of sources and processes it into practical information to determine the effectiveness of business process.

It involves three levels of processes. STAGING, INTEGRATION, ACCESS

Staging involves the process of giving the raw data and manipulating it.

Integration involves the process of categorising the raw data and logically storing it according to the requirement of the end-user.

Access involves the process of giving the categorised and logically stored data to the users in a coherent way that is easy to understand.

There are many tools available for Business Intelligence. Some of the popular tools (in no particular order) are:

  1. IBM Cognos
  2. Microsoft Business Intelligence
  3. Oracle Business Intelligence Enterprise Edition (OBIEE)
  4. Business Objects Enterprise XI
  5. Jaspersoft (Open Source)
  6. Talend Open Studio (Open Source), Talend Enterprise or Platform (with subscription)
  7. Pentaho software (have open source version)
  8. Qlikview Comprehensive BI Platform
  9. MicroStrategy
  10. Tableau

Business Intelligence helps an Organisation for its growth by analysing required business data.

Links

2057 questions
0
votes
4 answers

obiee 12c uploadrpd operation failed

./data-model-cmd.sh uploadrpd -I mytest.rpd -W weblogic -SI ssi -U weblogic -P weblogic I get the following error when I try to install the appropriate file. Error is : Operation Failed. An exception occured during execution, please check server…
m2h2
  • 33
  • 1
  • 5
0
votes
2 answers

How to get calculated measure to rollup correctly?

I have created a calculated measure that computes a weighted ratio for the current balance of all loans that fall into various risk ratings: WITH MEMBER [MEASURES].[Weighted Ratio] AS (Measures.[Current Balance] * [Risk Rating].[Loan Rating…
David McClelland
  • 2,686
  • 4
  • 28
  • 37
0
votes
0 answers

Show or hide report based on expression

Today i have one problem with SSRS reports while show or hide report based on expression i tried different expects but it is still not working following is my expression. =IIf(Parameters!P_Level.Value = "3", true, false) I tried following another…
Nikhil.Patel
  • 959
  • 9
  • 17
0
votes
1 answer

Catching MDX queries without profiler

How I can catch MDX running queries without profiler? I looks for something like DMV sys.dm_exec_requests, but for SSAS.
Testtest11
  • 367
  • 1
  • 11
  • 26
0
votes
2 answers

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…
Nicolas Raoul
  • 58,567
  • 58
  • 222
  • 373
0
votes
2 answers

Not able to see Business model and Business queries in SpagoBI Studio 5.2

I want to create a business model in SpagoBI Studio but I am not able to find the options Business model and Business queries in the Studio Resource Navigator. I am using SpagoBIStudio_5.2.0_linux64, and on Ubuntu 14.04. I have created a new SpagoBI…
Sunny Mane
  • 11
  • 4
0
votes
1 answer

Palo Suite 3.1, Ubuntu, missing OLAP Server

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 ?
Spredzy
  • 4,982
  • 13
  • 53
  • 69
0
votes
1 answer

Group by and concatenation in OBI 10g analytics

I have a problem in OBI analytics. I'm using OBI 10g. I have two columns: ID and supervisorID. As a result I want two columns: 1. the ID 2. and the concatenation of all the supervisorID of the ID in a second column. So If I have ID following…
Bigjo
  • 613
  • 2
  • 10
  • 32
0
votes
3 answers

Real time reporting software

I have this problem and was wondering if anyone can help. I have a number of data feeds (CSV files, web APIs) that I would like to report on but can't find anything open source or paid that can do the job. Basically I want to be able to attach any…
Dimitris
  • 2,030
  • 3
  • 27
  • 45
0
votes
0 answers

how to show error message when execute mdx query in pentaho BI

I'm using Saiku Analytics, when i run MDX Query and the Query error , the error message is always Error executing query. Please check the server logs or contact your administrator! How to get specific error message ? Then I can fix my query. Or…
NameDoesntMatter
  • 1
  • 4
0
votes
1 answer

Foreach Loop Container with more than one Input Constraint

I have a weird problem with Foreach Loop Container. I have a package to take backup of out SSAS cubes. We have both UDM and Tabular cubes. Considering below figure, based on a variable, flow should go to Find UDM Cubes OR Find TAB Cubes, so I used…
FLICKER
  • 6,439
  • 4
  • 45
  • 75
0
votes
2 answers

year to date running total for fiscal year

SELECT DISTINCT ACCOUNTDATE ,PROPERTYNAME ,rt.management from aaa t cross apply (select SUM(MANAGEMENT) as management from aaa where PROPERTYNAME = t.PROPERTYNAME and ACCOUNTDATE BETWEEN dateadd(MONTH,…
Swe
  • 11
  • 5
0
votes
1 answer

Passing parameter into an OLE DB component using parameters not variables SSIS

I'm having difficulty passing a parameter into stored procedure in my SSIS OLE DB Source. I keep getting [Get ************ [2]] Error: The SQL command requires a parameter named "@numberOfRecords", which is not found in the parameter mapping.] sp…
Olaolu Ajose
  • 23
  • 9
0
votes
1 answer

SSAS Role setup

I have a user that needs to have access to 2 different countries and based on that value a member set of another attribute is filled. So for the Country attribute, I have this: {[Sell To Customer].[Country Code].&[BE], [Sell To Customer].[Country…
KevinP
  • 217
  • 1
  • 5
  • 20
0
votes
2 answers

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…
Mike B
  • 15
  • 2
  • 4
1 2 3
…
99 100