Unable to find View columns in VO BICC

Siva Gollapalle

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

Nathan CCC

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

Nathan CCC

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?

Siva Gollapalle

Hi Nathan,

Thanks for your response.

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

Thanks.