Datawarehouse Architect

I am trying to create master repository in ODI and I encountered below error ception: java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'USERS' When I did little research I understood that I have not given unlimited quota access to my schema and I have given below access.

Template can also be uploaded from the BI Publisher. Browse the RTF template that has been saved and upload it into the BI Report by clicking the upload button as shown below.  Create a new Layout by selecting Layouts -> New  Enter the layout name and select the template, template type and output format.  Save the report and view the output. You can see the template name as the name uploaded from MS Word. 

Create a new template design to view details in Pie Chart. (If not already opened) Open the BI Publisher report or else log in to BI Publisher. In MS Word, select the BI Publisher> Open Template option. Open the report from the path My Folders>BI_Publisher_LabGuide. In the Word document that loads this report, select Insert> Cross Tab on the BI Publisher toolbar to define a format for the table data in the query. Drag and drop the Row values into the Layout region as shown below and click OK.  The created template looks like as shown below:  Change the word properties for all fields by double clicking on the field. Change the aggregate function in the code from sum to count. Click on the Properties tab and change the format and click OK. Similarly change the properties for every field. Include headers and footers as shown below. After making the necessary ch...

Create a new template design to view details in Pie Chart. (If not already opened) Open the BI Publisher report or else log in to BI Publisher. In MS Word, select the BI Publisher> Open Template option. Open the report from the path My Folders>BI_Publisher_LabGuide. In the Word document that loads this report, select Insert> Chart on the BI Publisher toolbar to define a format for the table data in the query. Drag and drop the Ename for Values and Loc for Labels. Give an appropriate title.  There are various types of charts available like Bar graph, Pie Chart, Line Graph, Area Graph, Ring Graph, Pareto Graph, Radar Graph etc. Select the one needed.  After choosing the type, select the style.  See the preview by clicking the Preview button.  Include headers and footers as shown below.

After making the necessary changes, upload the template by selecting Add-Ins->Oracle BI Publisher->Upload Template As A dialog box opens prompting to save the template in RTF. Click OK. Save the template in Rich Text Format A dialog box pops, asking for the Template name. Enter the Template name. The same name will be displayed in the BI Publisher screen.  After successfully uploading, a dialog box pops stating that the template has been added to the report. Click OK.  Check for the uploaded template in the BI Publisher Report.  Save the report and view the output. You can see the template name as the name uploaded from MS Word. View the output in different format. 

Create a new template from MS word. From MS Word application, log in to BI Publisher.  This displays the Open Template window. Ensure that BI Publisher is selected from the Workspace drop-down list Navigate and select the Employee_Location_Details report that you have created from My Folders> BI_Publisher_LabGuide. Click Open Report. Navigate and select the Employee_Location_Details report that you have created from My Folders> In the Word document that loads this report, select Insert> Table Wizard on the BI Publisher toolbar to define a format for the table data in the query. Create a template as given below: Change the format for the Hire Date data field to ‘Date’ type and format to ‘d-MMM-yy’ Insert header and footer for the created report. The template designed should look like as shown below.

Select the table 'EMP' and 'DEPT' and check the required fields. Define a join between these two tables as follows:  Click the box beside the DEPTNO column in the DEPT table. (See the following screens.)  Similarly click the box beside the DEPTNO column in the EMP table. These boxes when marked for joins turn to light gray.  Also note that a fine line joining the tables appears in the Model canvas. This is the result for the generated SQL.  Save the report