Unable to find View columns in VO BICC

Question

Hi

We are trying to find below View columns in a VO, can you please help us on how/where can we find them.

Below 2 columns are not available in "FscmTopModelAM.PjfSetupTransactionsAM.EventType"

attribute1

attribute2

Above 2 columns are available in table "PJF_EVENT_TYPES_B"

Below columns are not available in "CrmAnalyticsAM.CrmExtractAM.OkcBiccExtractAM.ContractHeaderExtractPVO"

attribute1,attribute2,attribute3,attribute4,attribute5

,attribute6,attribute7,attribute8,attribute9,attribute10,attribute11

,attribute12,attribute13,attribute14,attribute15,attribute16

,attribute17,attribute18,attribute19,attribute20

,attribute21,attribute22,attribute23,attribute24,attribute25,attribute26

,attribute27,attribute28,attribute29,attribute30

All the above columns are available in table "OKC_K_HEADERS_ALL_B"

Below column in not available in view "HcmTopModelAnalyticsGlobalAM.OrganizationAM.OrganizationUnitPVO"

attribute2

Above column is available in table "HR_ALL_ORGANIZATION_UNITS"

Can you please help in finding these columns?

Thanks

Siva Gollapalle · Answer

Hi Nathan,

Thanks for your response.

Can you please provide an update on the remaining views also, which were mentioned in the query?

Thanks.

Nathan CCC · Answer

Hi, When I configured additional information fields that are business intelligence enabled on project the system generated, when I ran the bi extender scheduled process to update the metadata repository database subject areas to get the columns added to the dimensions, a view object just for the descriptive flex fields called FscmTopModelAM.PJF_PROJECTS_ALL.FLEX_BI_PJF_PROJECTS_ALL_VI. Do you have something similar for the fields you have configured on event type FLEX_BI_PJB_EVENT_VI? Are your fields bi enabled? Did you run the biextender import process?

Nathan CCC · Answer

Hi,

For the first view object I think the additional information fields column(s) you are looking for attribure[n] do not exist - nothing to find! List columns in business intelligence cloud connector /biacm/

to get data lineage then view log from query all columns (you can do this because this object is used in the metadata repository database) using /analytics/saw.dll?IssueRawSQL

select_physical all * from "FscmTopModelAM.PjfSetupTransactionsAM.EventType" t