"dwh_oba_todo_v" table is not available in ODATA
search cancel

"dwh_oba_todo_v" table is not available in ODATA

book

Article ID: 251911

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

"dwh_oba_todo_v" table is not available in ODATA

STEPS TO REPRODUCE

  1. Login to a 16.0.3 Clarity environment
  2. Run the below DWH jobs
    • Load Data Warehouse (Full)
    • Load Data Warehouse Access Rights
    • Refresh Data Warehouse OData Model
  3. Connect this environment to any ODATA tools like Power BI, Tableau, Excel etc
  4. Retrieve all the tables and views available
  5. Query for dwh_oba_todo_v view in ODATA (the table is present in DWH schema)

Expected: dwh_oba_todo_v should be in ODATA 

Actual: dwh_oba_todo_v is missing from ODATA

Environment

Release : 16.0.3

Resolution

DE66982 - Engineering has confirmed that dwh_oba_todo_v canot be exposed in the ODATA instead expose the table DWH_CMN_TODO and this has been flagged as an enhancement and is added to Engineering backlog

Additional Information

The dwh_oba_todo_v is missing from dwh_odata_objects table so it's not included in the ODATA