Indexed 'Entity' Not Appearing in Alerts -> Data tab

[Eric_01]

Hello community!

I'm trying to get an answer on why my 'Transactions' entity does not show in the Alerts tab (Alerts -> Data). I want to load it into memory so that I can create scenario flows from it.

I already indexed the entity, but it does not appear in the above section. I even tried logging out and back in, but nothing changed.

Additionally, I tried to look for the 'views' that take data from the tables 'fsc_cash_flow_fact' and 'fsc_transaction_*', but I don't see those tables in the views coming from the 'core' schema. Where could they be? Or is the insertion for those tables different from other tables? This is a different topic btw.

Down below, I attached the images of my current situation. It's my first time posting in this channel, please bear with me if I'm trespassing any guidelines.

Is there something that I might be doing wrong? Please, guide me on how I can get this solved.

Thank you in advance!

[susantrueman]

Hi Eric

I recommend raising a ticket with SAS Technical Support who will be able to help with this question. Thanks.

[_austin_ · Accepted solution]

Hi Eric,

The Alerts -> Data tab does not require your table to be indexed in Visual Investigator to be visible in that table. In fact, since flows are typically scanning very large tables, it is common for the tables used for flow execution to not be indexed. 

There are some checks that the system does on a table before it puts it in that list. If you look in Appendix 1 of the SAS® Visual Investigator Administering Flows and Scenarios document, there is a Section called "Source Data Limitations" that lists those rules. 

• Tables with a multiple-column primary key defined (commonly referred to as a composite primary key) are not available for data source selection when creating a flow.
• Columns in a data source that include any of the following are not available for use in flows and scenarios:
  • variable character (varchar) columns without a defined length
  • user or group chooser field data columns
  • (Note that all other supported columns in the data source are available).
  • If a data source includes reference data columns, the Code column is available for use in flows and scenarios. The Reference Value column is not available.

Is the table missing from both the Alerts -> Data tab and from the Data Sources panel in Flow properties? Is the missing table using the same Data Store as the tables that are visible? If your table has a multi-column primary key, that would explain why the table is not available. If the table does not have a multi-column key, then I would agree with the previous comment that you should reach out to tech support.  

[Eric_01]

Thank you for your explanation! The issue was indeed related to the primary keys—my table had three columns acting as primary keys.
I reassigned them, and it worked.

Thanks again!