Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIA Load Plan - custom addition does not run

Received Response
21
Views
4
Comments
Robert Angel
Robert Angel Rank 8 - Analytics Strategist
in Oracle Business Intelligence Applications

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.

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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
    megamalex1 Rank 1 - Community Starter

    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
    Robert Angel Rank 8 - Analytics Strategist

    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
    John_K Rank 5 - Community Champion

    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.