topic Re: Information Map using more then one Subject with error in SAS Customer Intelligence

Information Map using more then one Subject with error

tfabri — Tue, 26 Feb 2019 17:11:05 GMT

Hi CI Experts!

Hi CI Experts!
I've started the Information Map configuration and I'm trying set up two subjects "Clientes" and "Apolices". First I created the relationship between this 2 tables, after I did the follow configurations - Custom options:

InformationMap : InfoMAP

        [Subject_ID_Clientes = Clientes]
        [Subject_ID_Apolices = Apolices]
        [MetadataTable_Prefix_Subject_ID_Clientes = Clie]
        [MetadataTable_Prefix_Subject_ID_Apolices = Apol]
        [Subject_Code_Subject_ID_Clientes = 2]
        [Subject_Code_Subject_ID_Apolices = 1]
        [MAMeta = Libname MAMeta "E:\TABELAS";]
        [From_Subject_ID_Clientes_To_Subject_ID_Apolices = OneToMany]
        [From_Subject_ID_Apolices_To_Subject_ID_Clientes = ManyToOne]
        [Subject_Default = Subject_ID_Apolices]

//SUBJECT 1

Apolices
[Subject_ID_1 = Subject_ID_Apolices]

Formapagto
[Level = Nominal]
[NoMetadata = True]

//SUBJECT 2

Clientes
[Subject_ID_2 = Subject_ID_Clientes]

Cliente
[Level = Id]
[NoMetadata = True]

Nacionalidade
[Level = Nominal]
[NoMetadata = True]

When I tryed use it on my Business Context (on CI) I can counts only fields from "Apolices" subject. Fields from "clientes" subject occurred an error (Nacionalidade: In MAIQService:getDataSelection:Index: 0, Size: 0)

Does anyone have any idea?

Best,

Re: Information Map using more then one Subject with error

jpsm70 — Tue, 26 Feb 2019 17:33:36 GMT

Hello,

Have you defined the UseInSubjectId property per subject level?

-Juan P

Re: Information Map using more then one Subject with error

tfabri — Tue, 26 Feb 2019 21:03:31 GMT

Hi @jpsm70,

Thank you for your answer.

I added "UseInSubjectId" in all fields. After it, I did an update on Metadatas. I tried use this fields on diagram (CI) but it's not appear. I can see two subjects with no fields.

Regards,

Re: Information Map using more then one Subject with error

jpsm70 — Tue, 26 Feb 2019 21:13:08 GMT

Hi,

"I added "UseInSubjectId" in all fields"

The UseInSubjectId should be use only for the primary key representing the subject level.

Perhaps the easiest thing would be for you to open a track with SAS Technical Support and go from there.

-JP

Re: Information Map using more then one Subject with error

tfabri — Thu, 28 Feb 2019 13:30:29 GMT

Thank you a lot for your help. It is working perfectly now.