Skip to main content

Home/ BI-TAGS/ Group items tagged extensions

Rss Feed Group items tagged

cezarovidiu

BI Brief - Four Legs of a Successful Business Intelligence (BI) Project Team - 0 views

  • 1. Project Sponsorship and Governance 2. Project Management 3. Development Team (Core Team) 4. Extended Project Team
  • 1. Project Sponsorship and Governance IT and the business should form a BI steering committee to sponsor and govern design, development, deployment, and ongoing support. It needs both the CIO and a business executive, such as CFO, COO, or a senior VP of marketing/sales to commit budget, time, and resources. The business sponsor needs the project to succeed. The CIO is committed to what is being built and how.
  • 2. Project Management Project management includes managing daily tasks, reporting status, and communicating to the extended project team, steering committee, and affected business users. The project management team needs extensive business knowledge, BI expertise, DW architecture background, and people management, project management, and communications skills. The project management team includes three functions or members: Project development manager - Responsible for deliverables, managing team resources, monitoring tasks, reporting status, and communications. Requires a hands-on IT manager with a background in iterative development. Must understand the changes caused by this approach and the impact on the business, project resources, schedule and the trade-offs. Business advisor - Works within the sponsoring business organization. Responsible for the deliverables of the business resources on the project's extended team. Serves as the business advocate on the project team and the project advocate within the business community. Often, the business advocate is a project co-manager who defers to the IT project manager the daily IT tasks but oversees the budget and business deliverables. BI/DW project advisor - Has enough expertise with architectures and technologies to guides the project team on their use. Ensures that architecture, data models, databases, ETL code, and BI tools are all being used effectively and conform to best practices and standards.
  • ...2 more annotations...
  • 3. Development Team (Core Team) The core project team is divided into four sub-teams: Business requirements - This sub-team may have business people who understand IT systems, or IT people who understand the business. In either case, the team represents the business and their interests. They are responsible for gathering and prioritizing business needs; translating them into IT systems requirements; interacting with the business on the data quality and completeness; and ensuring the business provides feedback on how well the solutions generated meet their needs. BI architecture - Develops the overall BI architecture, selects the appropriate technology, creates the data models, maps the overall data workflow from source systems to BI analytics, and oversees the ETL and BI development teams from a technical perspective. ETL development - Receives the business and data requirements, as well as the target data models to be used by BI analytics. Develops the ETL code needed to gather data from the appropriate source systems into the BI databases. Often, a system analyst who is a expert in the source systems such as SAP is part of the team to provide knowledge of the data sources, customizations, and data quality. BI development - Create the reports or analytics that the business users will interact with to do their jobs. This is often a very iterative process and requires much interaction with the business users.
  • 4. Extended Project Team There are several functions required by the project team that are often accomplished through an "extended" team: Players - A group of business users are signed up to "play with" or test the BI analytics and reports as they are developed to provide feedback to the core development team. This is a virtual team that gets together at specific periods of the project but they are committed to this role during those periods. Testers - A group of resources are gathered, similarly to the virtual team above, to perform more extensive QA testing of the BI analytics, ETL processes, and overall systems testing. You may have project members test other members' work, such as the ETL team test the BI analytics and visa versa. Operators - IT operations is often separated from the development team but it is critical that they are involved from the beginning of the project to ensure that the systems are developed and deployed within your company's infrastructure. Key functions are database administration, systems administration, and networks. In addition, this extended team may also include help desk and training resources if they are usually provided outside of development.
cezarovidiu

Adding Extensions to the Layout Editor - 11g Release 1 (11.1.1) - 0 views

    • cezarovidiu
       
      /middleware/user_projects/domains/obi/config/bipublisher/repository/Admin/Plugins
  • To implement a plug-in: Code the JavaScript plug-in using the guidelines described in Section 11.3, "Coding the Custom Plug-in." Place the JavaScript (.js) file in the following location <BI Publisher repository>\Admin\Plugins. Reload the Layout Editor. Your plug-in icon appears in the layout editor Insert menu.
cezarovidiu

Using the JDBC Connectivity Layer in Oracle Warehouse Builder - 0 views

  • For example, suppose you want to add support for MySQL. (As of OWB 11g R2, MySQL is not on the list of supported by default platforms.) All you need to do, though, is download the MySQL JDBC driver to put it into the OWB_HOME/owb/lib/ext directory, and add the platform definition for MySQL via a Tcl script that you can run from the OMB Plus console. The contents of such a script is beyond the scope of this article. However, if you want to look at one, check out this post by David Allan, where you’ll find a detailed example of how you can add support for MySQL to Oracle Warehouse Builder 11g Release 2. Also, there is a whitepaper on OTN called the "OWB Platform and Application Adapter Extensibility Cookbook", which goes into more depth than David’s post.
cezarovidiu

Template Builder Woes! (Oracle BI Publisher Blog) - 0 views

  • 1. Uninstall BIP desktop from control->Add or remove programs. 2. Open explorer and go to "C:\WINDOWS\assembly". 3. Check if there are assemblies which start with "TB" If present, remove them all. 4. Open the MS Word startup directory and check there are no files there. The directory is normally the following. C:\Documents and Settings\<user name><Application Data\Microsoft\Word\STARTUP5. Open MS Word and check that you don't see the BIP tool bar. -> If you see it, please move Normal.dot to another directory and try again.6. Please check that the OS user you use has an administrator privilege on the PC, this is really important. 7. Please go to Control Panel -> Add or Remove programs and check if the followings have been installed. Shared Add-in Extensibility Update for Microsoft .NET Framework 2.0 (KB908002) Shared Add-in Support Update for Microsoft .NET Framework 2.0 (KB908002) 8. Install BIP Desktop again
cezarovidiu

Bossie Awards 2014: The best open source applications | InfoWorld - 0 views

  • SuiteCRM was forked from the 6.5.x branch of SugarCRM because a segment of the community felt that SugarCRM Inc. was paying too much attention to its commercial editions and dragging its feet on updating the community edition. In addition to packaging up the latest SugarCRM codebase, SuiteCRM added a number of third-party extensions, resulting in a new system that is comparable to SugarCRM Professional in terms of features and functionality.
cezarovidiu

Does Excel Power Pivot Replace the Data Warehouse? | SQL Server BI Blog - 0 views

  • Excel Power Pivot is targeted for Personal and Team Business Intelligence (BI) solution use cases.
  • Power Pivot also is excellent for quick prototypes and proofs-of-concept.
  • no row level security,
  • ...2 more annotations...
  • The more advanced features include partitioning for large-scale data sources and role based security.
  • A data mart or data warehouse is often the blessed, single version of the truth since it uses governed, controlled data loading and ETL processes to combine disparate data sources, applies extensive business logic and proven data modeling design patterns that can securely, accurately and efficiently report data changes over time periods.
1 - 9 of 9
Showing 20 items per page