CDS View to get all IDs of Golden Record?

[former_member355106]

Hello together,

does exist an CDS View where I can search for one ID of an ID_ORIGIN and get all facets for this ID?

Example: Golden Record contains ID_ORIGIN SAP_C4C_BUPA with ID 1234 and ID_ORIGIN EMAIL with Adresse 1233@mail.com. Which CDS View could give me both IDs by searching only for one ID?

BR/

[vervinckt_joyca · Accepted solution]

Hi Oliver,

This is the association I used.

Kr

Joyca

[former_member355106 · Accepted solution]

Dear Joyce, sorry for asking again. You have been so kind in answering me all other questions maybe could you give me a last hint here?

Somehow the defined view is not visible in the Query App. I guess I have to define it as a Cube or Dimension. Right now only Dimension is possible.

1. Have you defined the CDS View as a Cube or Dimension? Why I can not define it as a cube?

2. Which Fields have you defined as a Represantative Key?

Would you be so kind to send me a screenshot of the details of the view definition also?

[vervinckt_joyca · Accepted solution]

Hi Oliver,

I set it to be a Cube.

But it's strange, when I go to Edit Mode, it indicates this is an invalid entry :s

Also when creating a new CDS view with these data sources, I cannot choose Cube :s

Luckily, my view still works, I had published it on 07.02.2019. Which is just before 1902. I wonder if anything in the 1902 update made it that Cube cannot be selected in this specific scenario :s

[vervinckt_joyca · Accepted solution]

I think maybe in an earlier version, the Facet data source might have been a Cube?

I've looked in the View Browser to check if there's other Views, which are a Cube, which are also based on CUAND_CE_IC_FCET table. There's the I_MKT_INTACTNCONTACTFACETCUBE view, but it has status "Not Released" 😞 However that one does contain an association between I_MKT_CONTACTFACET and I_MKT_CONTACTFACETDATA with a 0..1 cardinality; only it doesn't have a lot of columns...

All other views start from CUAND_CE_IC_FT_D and make an inner join with CUAND_CE_IC_FCET, so you don't get to see the "additional facets" without data associated...

I'm also out of ideas now 😞

[vervinckt_joyca]

Hi Olivier,

I made a custom CDS view and a custom analytical query for that.

Basically you want CUAND_CE_IC_FCET and CUAND_CE_IC_FT_D table, right? 🙂

like this? below I filter on email and get the other facets back based on that email*.

I didn't find any View in the View browser that I could use (meaning that was of type Query, otherwise the "create application" button doesn't activate).

So in custom CDS view, I used these two underlying views, selected the fields I needed, then built a custom query on it, so I could use it.

I used both Facet and Facet Data for my case.

But I do miss good old SE16 ...

*note you may need to tweak the view depending on your purpose. I filter on the email field in the FT_D table, meaning I only get the facets with that mail address.

In a second step I can take the GUID and filter on that to also get the facets without the data.

Maybe this would be possible in one step, not sure though.

Kr,

Joyca