Oracle Analytics Cloud and Server

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

Removing Internal and External Funding with Busines Group within OBIEE

Received Response
1
Views
7
Comments
3742958
3742958 Rank 2 - Community Beginner

Hi,

Internal and External Funding has been set up within the Business Group area in OBIEE.

However, how can this be removed please so that is just one row of data and not the 'duplicated' internal funding or external funding.

I also understand we cannot just ignore Internal Funding as it then removes the capital spend

Please can the steps to have these fields removed

Kind regards

Owen

Answers

  • Hi Owen,

    I'm sure the question make perfectly sense for you as you seem to have that thing in front of your eyes ....

    But we don't

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Sounds like he might be asking for support of a pre-built cloud offering ...

  • 3742958
    3742958 Rank 2 - Community Beginner

    Thank you for your responses.

    Having internal and external funding appears a Oracle feature that allows linking to projects and advises the funding flow.

    So when we run a Requisition, Purchase Orders or Spend report, we get the cost tot he particular subjective code which is fine, but then an additional row with the cost to the Internal Funding linked to Grants

    It must have been something that was part of the set up, but was wondering if it is the hierarchies one needs to look at to change this or maybe go back into the set up?

    Sorry if this doesn't make sense - its just a feature we have when running OBIEE reports

    Thanks

    Owen

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Owen,

    What my learned colleagues are trying to get across is:

    You seem to be talking about a pre-built solution based on one of the Oracle applications / other products.

    We're all pretty savy in the tech but most products / product offerings have such specific *content* that it's hard to respond in any meaningful way without having the product itself in production and running.

    OBIEE itself is an analytical platform and can pretty much do anything you want. And most likely even way more.

    The data model and structures underlying your implementation are a mystery to us though and may completely eliminate the possibility of doing or attaining certain things. That's why most in here are very vocal advocates against prebuilt stuff

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Owen - are you running the OBIA Procure and Spend Analytics App?  Sourced from EBS, PSoft, etc?

  • 3742958
    3742958 Rank 2 - Community Beginner

    Apologies for getting back only now

    We are looking at bringing in hierarchies with a hope this should support solving the issue and would like to advise if this does soon

    EBS is being used for the input side, and within OBIEE, the particular subject area is Procurement and Spend - Invoice Lines

    Kind regards

    Owen

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Since you are using OBIA, be absolutely sure you follow the guide lines for extensions and customizations ...