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
0 answers

Using a username/AD group name as a Crystal Report Parameter on BusinessObjects

I've got a parametrized report built with Crystal running on a BusinessObjects server. I would like to get the report to auto-populate the location parameter based on the user name or Active Directory group name. How do I implement this logic?…
Mike
  • 39
  • 1
  • 5
0
votes
1 answer

filter by variable value in report block

I could find no relevant answers in either StackOverflow or google. Perhaps one of you has the answer. This is a continuation from a previous question... In Business Objects Webi, I have two variables. One dimension, one measure. My goal is to…
mf.cummings
  • 303
  • 6
  • 20
0
votes
1 answer

SSIS - Convert a varchar field to unique identifier

Thanks in advance for this everyone. I have a source column which is a Business Key with a VARCHAR format in my source database. All fields contain only numeric values. (It's horrible) I want to extract that data, transform the format and load into…
Will
  • 228
  • 1
  • 2
  • 15
0
votes
1 answer

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…
mrjohn
  • 1,141
  • 2
  • 13
  • 21
0
votes
1 answer

How to group objects while exporting to CSV in SQL Server 2014?

I am trying to export my report to a CSV file. But, upon exporting the file the values are appearing in the reverse order. Here is an example of my report layout with few columns for your reference. The first one is a Tablix and the second one is a…
Julaayi
  • 403
  • 2
  • 8
  • 23
0
votes
2 answers

Is Date/Time dimension recommended in my case

I'm designing a data warehouse that has calls and telephony data in it. In my fact table (fact calls) I do have multiple DATETIME fields such as CallStart, CallEnd, CallAnswered, CallRecordSaved, etc... (all of those have year, month, day, hour,…
Fourat
  • 2,366
  • 4
  • 38
  • 53
0
votes
1 answer

Oracle RCU error unable to connect to DB

Am new to Oracle and trying to install BI. My database is on my local system. While am installing RCU unable to connect the database. I have Oracle 12C Thanks in advance.
sajeesh
  • 21
  • 1
  • 8
0
votes
1 answer

Things to Download for SSIS Package Developing in Visual Studio

I want to start devleoping SSIS packages. I want to do this in Visual Studio Business Intelligence Integration Services developer. It looks like Business intelligence is only available for Visual Studio 2013 at the latest. I currently have Visual…
user3739190
  • 111
  • 2
  • 9
0
votes
1 answer

Cognos Web Reports 7: Change Source of a Custom Report View

Is it possible to change the source of a custom report view in Cognos Web Reports? We're using version 7.5. Cheers James
james.mullan
  • 149
  • 2
  • 3
  • 16
0
votes
3 answers

SSIS loading data error

I have a CSV file which contains this…
BI_Reporting
  • 47
  • 1
  • 8
0
votes
0 answers

SSRS 2014: The report parameter has a DefaultValue or a ValidValue that depends on the report parameter. Forward dependencies are not valid

After trying a lot on Google, I ran out of luck and here I am seeking your help. I am trying to create a dataset in SSRS using a Stored Procedure and I am having hard time. Could someone please shed me light of what I am missing? Here is the how my…
Julaayi
  • 403
  • 2
  • 8
  • 23
0
votes
1 answer

SSRS - How to lay out query results in style other than generic table

I am creating an SSRS report in Visual Studio 2012. I have a parameter ID and the following query: SELECT ID, Name, Email, Title, Address FROM EmployeeTable WHERE ID = @ID ID is a unique identifier, so this query will only ever return one set of…
thnkwthprtls
  • 3,287
  • 11
  • 42
  • 63
0
votes
2 answers

What database Palo OLAP server handles?

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

Comparing strings with NULL gives wrong results

I have a scenario where in I need to compare data of two columns. Both columns are Strings. below are the scenarios to be covered Scenario 1 : if column 1 has a value and Column 2 is NULL = its a Mismatch Scenario 2 : if column 1 is NULL and Column…
chaithra Kashyap
  • 1
  • 1
0
votes
1 answer

Is there a way to display the Error Message in SAP BusinessObjects notifications?

I see there are placeholders such as %SI_NAME% and SI_OWNER but what I'm looking for is the ability to actually send the Error Message (e.g. Error in File Parameter has no value. Details: errorKind) in the failure notification email to make it…
grpcMe
  • 1,367
  • 5
  • 15
  • 28
1 2 3
…
99
100