Showing posts with label DAC. Show all posts
Showing posts with label DAC. Show all posts

Date dimension in BI Apps 7.9.5 is not checked to be Time dimension. Do you know if there is any particular reason why it is so?




I found an answer to something that bothered me for a while.
In setting up a Time dimension, there are requirement of the physical Tables that can be used, for e.g. Time Dimension table cannot join any physical table other than the fact table Time Dimension sources on the physical layer cannot be part of a complex join In the BM layer any logical Dimension defined as a Time Dimension cannot be part of any other logical tables . In the current 7.9.5 rpd the Date Dimension does not meet some of these requirements So if we were to designate the out of the box OBIApps rpd Date dimension as time dimension we can not have complex join to w_day_d in the physical layer. Currently out of the box OBIApps rpd has several complex join defined with the w_day_d_common alias table which is the detailed level LTC in the Date logical dimension. This issue causes error if you then try to check the time dimension flag and do a consistency check.
A comment on this from one of our Consultant as below “apps 7.9.5 was not ready to convert it to a true time dim. If you check the checkbox you will see all of the consistency errors. Part of it is due to the date fields being used in the inner joins of LTSs on other Dims and Facts which is a no-no for the Time Dim. It is easier just to create your own Time Dim that is used for the Time Series formulas. Or you could configure time series the old school way.” However the OBI 7.9.6 apps does have the Date Dimension checked as a Time Hierarchy. Also an additional response from Engineering as below
==================== The simple answer was that we didn’t use the OBIEE Time Series functions in BI Apps 7.9.5, and used them in BI Apps 7.9.6, hence configuring the Date dimension as a time dimension. In BI Apps 7.9.5, none of the new OBIEE Time Series functions were used. This was because the functionality was immature and had many bugs. These bugs were fixed in OBIEE 10.1.3.4.1 and BI Apps 7.9.6 has uptaken and used the new Time Series functions quite a bit. So for correct functionality of BI Apps 7.9.6, OBIEE 10.1.3.4.1 is a must.
This is interesting. My favorite part is “In BI Apps 7.9.5, none of the new OBIEE Time Series functions were used. This was because the functionality was immature and had many bugs. These bugs were fixed in OBIEE 10.1.3.4.1″ – soif you’re on 10.1.3.2. – you should upgrade as soon as possible (although this might mean months). I knew time dim was broken for a while – it’s just an official confirmatio

Peer to Peer Merge


10.7 About the Peer to Peer Merge Option
This section includes the following topics:
■ Peer to Peer Merge: High-Level Process Flow
■ Peer to Peer Merge: Procedure for Merging
The Peer to Peer Merge option enables you to merge DAC repositories of different
instances of the same release. For example, in a development environment you may
have two instances of a DAC Repository used with Oracle BI Applications release 7.9.5
that you want to merge.
10.7.1 Peer to Peer Merge: High-Level Process Flow
Figure 10–5 shows a high-level process flow for using the Peer to Peer Merge option to
merge DAC repositories of different instances of the same release.
The term base is used to refer to a source or target container that you have not changed
or customized in any way.
Figure 10–5 Merge Process for Peer to Peer Merge Option

In Step 1 of the high-level process flow, you export one instance of the existing
customized source system container to the file system and then import this container
into the repository temporary tables. This repository is referred to as the source in the
Upgrade/Merge Wizard.
In Step 2, you create a Difference Report that compares the instance 1 container
(including customizations) with the instance 2 container (including customizations).
The instance 2 container is referred to as the target.
In Step 3, you accept or reject the objects that the Difference Report shows as being
present or changed in the source but not the target. See Section 10.8.3, "Possible
Repository Merge Outcomes Based on Your Decisions" for a description of how objects
are merged based on the action you take.
In Step 4, after you have resolved the differences, you then execute the merge. In Step
5, the Upgrade/Merge Wizard references the customizations in the newly merged
container with the instance 1 base container.
10.7.2 Peer to Peer Merge: Procedure for Merging
Follow this procedure to use the Peer to Peer Merge option to merge DAC repositories
of different instances of the same release.
Before you begin this procedure you should review the section "Resolving Object
Differences in the View Difference Report" to gain an understanding of your options

for resolving object differences.
To merge two DAC repositories of different instances of the same release
1. Navigate to the Upgrade/Merge Wizard by selecting Tools, then DAC Repository
Management, and then Upgrade/Merge Wizard.
2. From the drop-down list, select Replace Base, and then click OK.
The Import Source System Container dialog box appears.
3. Click Change import/export folder to navigate to the directory that holds the
metadata files for instance 1 of the source system container you want to merge.
4. Select the appropriate container from the Source System Container drop-down list,
and click OK.
5. In the Importing Tables dialog box, re-type the text in the text box to confirm you
want to proceed, and click Yes.
When the import process is complete, the Importing Tables dialog box tells you
how long the process took.
6. Click OK.
The Create Difference Report dialog box appears.
7. Create the Difference Report to view the differences between the instance 1
container and the instance 2 container.
a. Enter a name for the Difference Report, or leave the default name.
b. In the Existing Container drop-down list, select the instance 2 container.
c. (Optional) Enter a description for the Difference Report.
d. Click OK.
When the Difference Report is complete, the Creating Difference Report dialog
box tells you how long the process took.
e. Click OK.
The View Difference Report dialog box displays the differences between the
instance 1 and instance 2 containers.
8. In the View Difference Report dialog box, resolve the differences between the
instance 1 and instance 2 DAC repositories. The instance 1 repository is referred to
as the source or existing container, and instance 2 as the target or new container.
For detailed information about the View Difference Report, see "Resolving Object
Differences in the View Difference Report".
To resolve the differences, you either accept or reject the objects that appear as new
or changed in the instance 1 container but do not appear in the instance 2
container.
a. In the navigation tree, select the repository object for which you want to view
the differences between the instance 1 and instance 2 containers.
If the object selected in the navigation tree is a hierarchical object, the subtabs
for the child objects appear in the bottom pane of the Object Difference
window.
b. (Optional) Filter the objects that appear in the top, right window by selecting
one of the options from the drop-down list in the toolbar.
c. For parent objects in the top pane and any child objects in the bottom pane,
accept or reject the object in the difference list by selecting or deselecting the
Accept Source check box.
For detailed information about these options and the merge outcome, see
"Possible Repository Merge Outcomes Based on Your Decisions".
Note: If a child object has been changed but not the parent object, the
parent object will still appear in the Object Difference window even
though it has not been changed.
d. (Optional) Once you have made a decision about whether to accept or reject
the difference, select the Resolved check box to indicate you have resolved the
object.
e. Repeat Steps a, b, and c, until you have resolved all object differences.
f. Click Merge.
The Merge dialog box appears and lists the details of the merge.
9. Click Merge to begin the merge process.
10. Click OK in the Merging Repositories dialog box when the merge process is
complete.

This section includes the following topics:
■ Replace Base: High-Level Process Flow
■ Replace Base: Procedure for Upgrading
The Replace Base option enables you to upgrade the DAC Repository when you are
phasing out an older release of a transactional application and moving to a newer
release, for example, phasing out Siebel 7.5.3 and moving to Siebel 7.8.
10.6.1 Replace Base: High-Level Process Flow
Figure 10–4 shows a high-level process flow for using the Replace Base option to
upgrade the DAC Repository when you are phasing out an older release of a
transactional application and moving to a newer release.
The term base is used to refer to a source or target container that you have not changed
or customized in any way.
Figure 10–4 Upgrade Process for Replace Base Option


In Step 1 of the high-level process flow, you import the repository data for the new
base container into the repository temporary tables. This repository is referred to as the
source in the Upgrade/Merge Wizard
In Step 2, you create a Difference Report that compares the new base container (source
repository) with the existing base container (including customizations). The existing
base container is referred to as the target
In Step 3, you accept or reject the objects that the Difference Report shows as being
present in the source but not the target or changed in the source but not the target. See
Section 10.8.3, "Possible Repository Merge Outcomes Based on Your Decisions" for a
description of how objects are merged based on the action you take.
In Step 4, after you have resolved the differences, you then execute the merge. In Step
5, the DAC references the customizations in the newly merged repository with the new
base container.
Note: The repository data is imported from a file system and should
be in the DAC 10.1.3.4 format. If it is in the 7.9.x format, you should do
the following:
1. Restore the repository data into a database using the 7.9.x DAC (using the
regular DAC import process).
2. Install and configure DAC 10.1.3.4 to the 7.9.x repository.
3. Export the relevant source system container to a file folder.
The metadata in the folder in Step 3 above will become the source for this
upgrade.
10.6.2 Replace Base: Procedure for Upgrading
Follow this procedure to use the Replace Base option to upgrade the DAC Repository
when you are phasing out an older release of a transactional application and moving
to a newer release.
Before you begin this procedure you should review the section "Resolving Object
Differences in the View Difference Report" to gain an understanding of your options
for resolving object differences.
To upgrade an existing DAC Repository
1. Navigate to the Upgrade/Merge Wizard by selecting Tools, then DAC Repository
Management, and then Upgrade/Merge Wizard.
2. From the drop-down list, select Replace Base, and then click OK.
The Import Source System Container dialog box appears.
3. Click Change import/export folder to navigate to the directory that holds the
metadata files for the new base container to which you are upgrading.
4. Select the appropriate container from the Source System Container drop-down list,
and click OK.
5. In the Importing Tables dialog box, re-type the text in the text box to confirm you
want to proceed, and click Yes.
When the import process is complete, the Importing Tables dialog box tells you
how long the process took.
6. Click OK.
The Create Difference Report dialog box appears.
7. Create the Difference Report to view the differences between the new and existing
DAC repositories.
a. Enter a name for the Difference Report, or leave the default name.
b. Select the appropriate existing container.
c. (Optional) Enter a description for the Difference Report.
d. Click OK.
When the Difference Report is complete, the Creating Difference Report dialog
box tells you how long the process took.
e. Click OK.

Simplified Refresh From Base Option


10.5 About the Simplified Refresh From Base Option
The Simplified Refresh From Base option is similar to the Refresh Base option. It
allows you to upgrade from a DAC Repository from an older release of Oracle BI
Applications to a new release, but you cannot compare repositories and create a
Difference Report.
If you want to upgrade a DAC Repository from an older release of Oracle BI
Applications to a new release and you want to compare repositories and create a
Difference Report before merging the repositories, you must use the Refresh Base
option. See "About the Refresh Base Option" for more information.
Before you begin this procedure, do the following:
■ Determine what customizations were made to your existing DAC Repository.
■ Make sure you have renamed and backed up your existing DAC Repository into a
different database. When you backup the DAC Repository, you export the DAC
metadata, in XML format (using the DAC's Export tool), into a folder other than
the standard DAC export folder where backups are stored (DAC\export). For
instructions on exporting DAC metadata, see "Exporting DAC Metadata".
To upgrade the DAC metadata repository
1. Upgrade your existing DAC Repository tables to be compatible with the new DAC
Repository release.
a. Configure the new DAC client version to read the DAC metadata from your
existing DAC Repository.
b. Log in to the DAC and select Yes if prompted to upgrade the repository tables.
2. Export the custom applications from your existing custom repository to a folder
other than the standard DAC export folder (DAC\export) or the folder into which
you backed up metadata in the previous format.
3. Import the new DAC metadata for your application from the standard DAC
export folder (DAC\export). Select the Truncate Repository Tables check box.
For instructions on importing DAC metadata, see "Importing DAC Metadata".
4. Import the customized DAC metadata that you exported in Step 2, and deselect
the Truncate Repository Tables check box.
This will append all the custom data to the repository, thus bringing in the
customizations, which include the following:
■ All modified data.
■ All newly created custom data.
■ All deleted data.
5. Refresh the source system container to locate any missing objects in your
customized application. The missing objects are any new objects that the
preconfigured applications may have that are not referenced in the custom
applications.
a. Navigate to the Upgrade/Merge Wizard by selecting Tools, then DAC
Repository Management, and then Upgrade/Merge Wizard.
b. From the drop-down list, select Simplified Refresh From Base, and then click
OK.
c. Select the appropriate container from the Source System Container drop-down
list, and click OK.
d. Confirm that you want to refresh the source system container.
6. Rebuild all the subject areas and execution plans in your customized application to
include any new changes in the object dependency. For information about
building subject areas and execution plans, see "Customizing DAC Objects and
Designing Subject Areas" and "Building, Running and Monitoring Execution
Plans".

Popular Posts