Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

deleted join and timestamp

dianapApr 5 2013 — edited Apr 19 2013
Hi All,

I have a workbook based on folders of a business area.

I did not know that deleting and recreating joins would caused the workbook not opened anymore.
Now a join item dependency error shows up.

I have learned that this has to to do with the identifier of the join.

The problem is that the workbook has a lot of worksheets, and they are old workbooks where as the documentation exist on as what is contained in the workbook.
So it is impossible to recreate the workbook.

I have also read something about a timestamp.
Would an update of the timestamp solve the problem and get the workbook to open again?

There are also other workbooks based on the same business area (which are working fine), will these be affected if the timestamp is updated?
Will other business area's also be affected?

Thanks,
Diana

Edited by: dianap on Apr 5, 2013 10:27 AM

Comments

user7417334
If you re-create the join with the exact name / identifier you can still open the workbook without any problem.
Make sure it is similar join which was deleted.
dianap
Thanks for the feedback.

The thing is I don't know the exact identifier anymore of the deleted joins.

Regards,
Diana
user7417334
Do you have any other instance, where you can find the identifier for the same join ?
dianap
No :(
user13716376
There is a workbook DUMP utility that will have a section that will show the EXACT name of the join for updating .. then the the workbook will open
dianap
Thanks,

Where is this workbook DUMP utility?

Diana
dianap
Hi,

After some search, I found how the dump works.
So I executed this.

For some joins, it's showing that the name has been changed:
Example: 
*** Found in EUL by id *** Name has changed to r_area_well.r_area_s 1
So now I changed the name of the joins in the BA to the naming showing in the file ( for this example: r_area_well.r_area_s 1).

But still the workbook will not open. It keeps giving the item dependency not found error.

Diana
user7417334
I guess this time its looking for another item and identifier which might have been deleted. More investigation needs to continue
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 17 2013
Added on Apr 5 2013
#business-intelligence-applications, #business-intelligence-foundation, #discoverer
8 comments
628 views