Business Intelligence

Business Intelligence for Financial Module

I'm looking for a BI demo for EBS Financial Modules (AR, AP, GL, etc)

Business Intelligence

I am planning on pursuing a BI reporting course. Business Objects (BO) is the tool of choice to me. I am however not clear what the difference between Crystal Objects 2008 and Web Intelligence (Business Objects Enterprise XI3) is. Actually, my career progression roadmap is to also do a data...

SAP BI Reporting Strategy

We are running SAP R/3 4.7 and we plan to implement SAP BI 7.0 (with ECC6) in the next year. I'm looking for advices to write a BI Reporting Strategy where I have to define the high level criteria that should be used to select the first R/3 reports to be best candidate to be migrated in BI. I...

What permissions are necessary to allow an SSIS script to read an excel file in a SharePoint Library?

I am developing a datamart to feed Performance Point dashboards/scorecards. To deal with managers who do not have a database source, I will have them submit an excel 2003 file to a SharePoint document library (by email). the excel file will have a consistent format. I am developing an SSIS script...

Sequence of metrics during the making of chart in business intelligence

is there any way of changing the sequence of metrics during the making of chart in business intelligence??

SSIS package

I am supposed to Run an sproc /script for more than one database. I thought of scheduling this sproc as a job for all database instances. But, DBA's suggested me to go with SSIS Package. Can any one quide me in doing this.

Spss data analysis

Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don't know which of THESE...

Error messages in Business Intelligence Development Studio on SQL Server Integration Sevices

I am new to SQL Server Integration Services (SSIS). When I went into Business Intelligence Development Studio (BIDS) and tried to create a new project, I received this error message: "Could not load or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies. The system...

Live production numbers as screen saver

We count the cattled killed in a slaughter facility and this data changes every 2.6 min. I want the screen saver (windows) to reflect the current kill number and will update say every three minutes.

BI Strategy

Hi Friends We are implementing new project and I'm new to this stage. Could anyone provide me the BI strategy documentation and how can we prepare it? Regards, Chama.

How do I integrate SQL Server Integration Services and Blaze Advisor?

I am a Microsoft Business Intelligence (BI) Developer and currently working on a Pharmaceutical BI project. The client wants to integrate his Blaze Advisor rule engine to SQL Server Integration Services (SSIS) so that he can change the rules in Blaze Advisor any time and see the effect of it on the...

Linking SQL Server databases to create DTS packages

I want to create a DTS package in SQL Server for the following problem: 1. Table T1 in Database DB1 in server1. 2. Table T2 in Database DB2 in server2. 3. Table T3 in Database DB3 in server3. The DTS package will be created in DB3. I need to copy data from T1 and T2 based on T1.ID = T2.ID, from...

XML Publisher with Shipping Docs

We are trying to use rtf Templates for our shipping docs. When we launch the concurrent request individually they work great. But when we use Ship confirm (which launches the doc set automatically) the xml is generated but the pdf format is not. Looking at the submitted requests, the layout has...

XML Publisher Issue

We can't output a concurrent request via XML Publisher... We can create data definitions and link data templates (.rtf files) through the app, when we attach a data.xml preview file, we can preview the output correctly. When we actually attempt to run the concurrent request, the output shows the...

Running a script at specified runtime

I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks