BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
tfabri
Obsidian | Level 7

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,

TF

1 ACCEPTED SOLUTION

Accepted Solutions
jpsm70
SAS Employee

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

View solution in original post

4 REPLIES 4
jpsm70
SAS Employee

Hello,

 

Have you defined the UseInSubjectId property per subject level?

 

-Juan P

tfabri
Obsidian | Level 7

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,

TF

 

 

jpsm70
SAS Employee

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

tfabri
Obsidian | Level 7
Thank you a lot for your help. It is working perfectly now.

How to improve email deliverability

SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1385 views
  • 0 likes
  • 2 in conversation