OBIA Load Plan - custom addition does not run

Robert Angel

Hi,

I followed the advice in the manuals on creating custom folders for SIL, SDE etc.

I have built custom scenarios that I need to run as part of the standard SDE / SIL etc.

The advice seemed to be to add new folders to the load plan by duplicating the Custom 'stub' folder in ODI, which I have done.

I have followed the advice but find that when I use Configuration Manager to regenerate it does not see the new folders, is there something very specific I have to do on the naming, I have followed the original format.

Anyone shed any light on this final step, the manual is less than crystal clear on this point?

thanks,

Robert.

Robert Angel

Anyone have any insight on this at all please?

As it stands I have two options, neither of which I am keen on; -

1. Amend one of the standard scenarios to call the custom scenarios when it finishes - problems; will lose this come the day the client upgrades

2. Create a wholly new load plan and run it independent of the standard load plan - problems; need to ensure it runs after standard load

Anyone suggest me how to get the standard routines to work with the addition of custom folders, created following the documentations guidance??

megamalex1

I've not touched OBIEE/OBIA for 18 months but did this up to version 11.1.1.9.2. Logically it's similar to Informatica if not very clear in the documentation. There should be no need to create a seperate load plan unless you're creating a fully custom analytic/data mart from your own adapter.

Assume you're just adding in Category 1 / Category 2 changes to exising analytics.... You still create any "Custom" folder(s) and you keep the original mappings (inc. versions), you just want the load plan to call the "Custom" scenarios (updated/new mappings).

Just scanned current verion 11.1.1.10.1 documentation links -

Category 1 Customizations: Adding Columns to Existing Fact or Dimension Tables

The above is straightforward but I do recall having to add additional load plan component steps using BIACM -

Category 2 Customizations: Adding Additional Tables

Oracle support had (has) extensive knowledge articles that should be accessible that covered off examples supported from various bugs (i know i raised a few) which should give you any missing pieces or examples to resolve. If in doubt you can always raise a support ticket :-)

Robert Angel

Hi,

thanks for your input, the issue with this proved to be that the solution was only updating dimension tables, and as such we had not added it to a FACT group. When we added it to a fact group then it works, even though in this case the solution is entirely factless.

Hope this helps someone else who finds themselves in the same situation.

John_K

You also have to ensure that you create foreign keys (not defined at the database level though - only in the logical model) between your dimensions and facts.