SAP Knowledge Base Article - Public

2891423 - Partial tables and views are listed when creating a Dataset based on Live Data Repository (SAP HANA) in SAP Analytics Cloud (SAC) when there are huge numbers of tables in HANA database

Symptom

Partial tables and views are listed when creating a Dataset based on Live Data Repository (SAP HANA) in SAP Analytics Cloud (SAC) when there are huge numbers of tables in HANA database

Environment

  • SAP Analytics Cloud (Enterprise) 2020.3.2

Reproducing the Issue

  1. Prepare SAP HANA database. In the database, prepare huge number of tables and views under a lot of catalogs.
  2. Configure SAP Cloud Connector and Data Repositories in Datasource configuration in SAP Analytics Cloud to connect to this HANA database.
  3. Create a new Dataset, choose Live Data Repository (SAP HANA) and select the configured repository.
  4. In the coming Select a table page, notice not all the tables are returned in the list.

Cause

It is limited to show first 4000 tables and views which are sorted by Last Modify Time.

Resolution

Set access rights for the HANA user which is used in Data Repositories, limit the tables and views number to be less than 4000.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-PR , SAC Predicitive , Problem

Product

SAP Analytics Cloud 1.0