Group items tagged

Step 3: Edit the my.cnf file

Search for the following line:[mysqld] Make sure line skip-networking is commented (or remove line) and add following line:bind-address=YOUR-SERVER-IPSo if your IP is 69.195.199.51 the entire block should look like this:[mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer_size = 16K max_allowed_packet = 1M table_open_cache = 4 sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 128K bind-address = 69.195.199.51 # skip-networking

Step 4: Save & RestartSave your edits by clicking on the Save button and restart MySQL by clicking RestartStep 5: Grant access to remote IP addressGo to the terminal in the control panel and log in (or connect via SSH) and connect to your MySQL database.$ mysql -u root -p mysqlGrant access to a new database If you want to add a new database called foo for user bar and remote IP 69.195.199.100 then you need to type the following commands at mysql> prompt:mysql> CREATE DATABASE foo; mysql> GRANT ALL ON foo.* TO bar@'69.195.199.100' IDENTIFIED BY 'PASSWORD';How Do I Grant Access To An Existing Database? To grant access to an existng database called foo for user bar and remote IP 69.195.199.100 type the following command At mysql> prompt for existing database, enter:mysql> GRANT ALL ON foo.* TO bar@'69.195.199.100' IDENTIFIED BY 'PASSWORD';

What this means in practice is that when the BI Server component starts up, it creates and reserves a number of threads in advance, determined by a number of parameters including SERVER_THREAD_RANGE.

You can see these threads running and ready to perform tasks for the BI Server component by using a tool such as Process Explorer for Windows

Thinking it through a bit, any given single query is, to a certain extent, only really going to use a small part of the total amount of CPUs available on a server, because it’s not the BI Server that runs queries in parallel, it’s the underlying database. For example, a single analysis against a single Oracle Database datasource would only really need a single BI Server thread to handle the query request, but when the underlying database receives the query, it might use a large number of its CPUs to process the query, returning results back to the BI Server to then pass back to the Presentation Server for display to the user.

mysqldump -h localhost -u [MySQL user, e.g. root] -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql

Extract the Database

relational database management systems (DBMSs) used as platforms for data warehouses

It is important to note that a DBMS does not in itself constitute a data warehouse — rather, a data warehouse can be deployed on a DBMS platform.

a data warehouse is simply a warehouse of data, not a specific class or type of technology

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.

OBIEE 11g skills, both in terms of new functionality (mapping, analyses, KPIs and Scorecards etc) and new infrastructure (WebLogic, EM, OPSS etc) A smattering of Essbase skills, focused mainly on the integration with OBIEE and Essbase (and the many workarounds and gotchas) Good ODI skills, both in terms of the basics, but also being able to write knowledge modules, integrate with OBIEE, deployment and migration Solid database skills – OBIEE gave the illusion through aggregates etc that database tuning was redundant, but time has shown it’s by far the biggest success factor in a project – get the database design and optimisation wrong, and your project is toast. You need to know partitioning, materialized views, index types, and increasingly, you need to get yourself on an Exadata project as customers are buying the technology but you can’t teach it to yourself at home BI Apps skills, but watch out for everything changing when BI Apps 11g comes out, and be prepared to learn the Fusion Apps and JDeveloper if you want to stay in the game Looking to the future, keep an eye on technologies such as in-memory (TimesTen), mid-tier caching (Coherence), plus technologies such as Business Activity Monitoring (BAM), “big data” (Hadoop, large data sets, NoSQL), complex event processing and maybe products such as Qlikview, just in case Oracle buys them, or at least to know what the competition are up to, or more importantly pitching to your boss

The other thing to bear in mind of course, if you’re an Oracle BI developer, is that you need to have great business, communication and data modeling skills.

 Table Eav_Entity_attribute

Installing and Configuring Apache

apt-get install apache2

etc/init.d/apache2 start|stop|restart|reload|force-reload apacheclt start|stop|restart|...

All of which led me to FusionCharts, which is a brilliant set of flash charts and widgets.

All I had to do was figure out how to integrate it into my app. First I had to write a function to extract the data I needed from my database and output it as correctly-formatted XML. That bit was easy so I won't bore you with it.

Next I uploaded the Flash (SWF) file for my chart into my workspace. (Tell me something: when you upload an image to your application using Apex's image uploader you refer to it by pointing at # APP_IMAGES#, so how do you think you'd refer to a file you've uploaded using Apex's file uploader? #APP_FILES#? Wrong! Illogically, all files uploaded into your application should be pointed at using the #APP_IMAGES# substitution string.)Finally, I created a dynamic PL/SQL content region outputting the necessary wrapper tags for my Flash movie (which I copied from the FusionCharts examples), pointing it to my uploaded swf file and feeding it the XML from my database function (which I call in "before regions" page process).

OBIEE, at the BI Server level. lets you define query limits that either warn or stop users from exceeding certain elapsed query times or number of rows returned. Assuming you define a “standard” group for most OBIEE users, you might want to stop them from displaying reports (requests) that return more than 50,000 rows, whilst you might want to warn them if their query takes over five minutes to run.

@apexins.sql SYSAUX SYSAUX TEMP /i/

@apxchpwd.sql

Shut down with normal or immediate priority the Oracle Database instances where you plan to install Oracle Application Express.

Plug-in Details: CLOB Load Have you ever used a Rich Text Editor item type in APEX? Has the amount of text ever exceeded 32k? Choke! And so begins the search for a work around... While work arounds exists they can be a little difficult find and repeat each time you need them. We designed the Enkitec CLOB Load plug-in to simplify and standardize how large amounts of text are moved from the database to APEX page items and then back to the database.