search cancel

dwh_rdm_item_summary_facts table missing in ODATA

book

Article ID: 237898

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

"dwh_rdm_item_summary_facts" table is not available in ODATA

 

Environment

Release : 16.0.1

Cause

STEPS TO REPRODUCE
1. Login to a 16.0.1 Clarity environment
2. Run the below DWH jobs
   --> Refresh ODATA Model
   --> Load DWH Access Rights
   --> Load DWH Full Load
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_rdm_item_summary_facts table in ODATA (the table is present in DWH schema)

Expected: Being a facts table, dwh_rdm_item_summary_facts should be in ODATA
Actual: dwh_rdm_item_summary_facts is missing from ODATA

 

Resolution

This is a defect DE64542 and is fixed in 16.0.2