Skip to Content
Technical Articles
Author's profile photo Thomas Fery

SAP Analytics Cloud – Administration Cockpit

Today I am excited and happy to announce the

SAP Analytics Cloud – Administration Cockpit.

Updates:

April 4 2022 – Demo Video

Why an Administration Cockpit?

Authorization assignments regarding user, team, roles, sharing settings of folder, analytic applications, stories, etc., where-used of models, data actions, etc., and questions related to housekeeping can now be identified and reported even more easily.

The Administration Cockpit aims to help the administrators to answer those questions and look behind the curtains. It consists of one main application, the Administration Cockpit itself, which offers the possibility to open the other applications, so-called Fact Sheets. The Administration Cockpit helps to get an overview whereas the Fact Sheet provide detailed information.

When do I get it?

With Wave 2022.01 and 2022.Q1 Quarterly Release the analytic application called SAP Analytics Cloud – Administration Cockpit and 11 corresponding analytic applications called Administration Cockpit | Fact Sheet | * will be released.

Where can I get it?

It will be deployed as default into your system folder into the SAP Analytics Cloud content folder. So there is no need to import it from the Analytics Content Network. Everything will be available out of the box for your convenience. The system folder location was described in 2021.Q1 quarterly release. (Please check SAP Analytics Cloud Performance Analysis Tool for details.)

What’s in it?

The content consists of a main application and a folder containing several supporting analytic models and analytic applications.

  1. SAP Analytics Cloud – Administration Cockpit analytic application
  2. Administration Cockpit Resources folder:
    1. RESOURCE
    2. LIVE_USER
    3. LICENSE
    4. RESOURCE_RECENT_ACCESS
    5. SESSION
    6. MEMORY_CONSUMPTION
    7. ERROR_LOG
    8. ACTIVITY_LOG
    9. USER_ADOPTION
    10. Supporting analytic applications

Important Note:

  1. Please always use the main analytic application SAC_ADMIN_COCKPIT as a starting point to avoid errors.
  2. Please do not rename the analytic applications to avoid errors.

Administration Cockpit Framework

The main application of the Administration Framework is divided into 11 sections, a section per topic areas. Three of them are already available: SAP Performance Analysis Tool, SAP Performance Statistics and Analysis and the Data Action Statistics and Analysis. These have all been embedded in the last three sections for convenience and remain in their folder unchanged, so no further explanation is needed. Please visit the existing blog post for a refresher.

The new content will now be discussed now one by one:

Home

The “Home” screen and starting point of the Administration Cockpit will be delivered with prebuilt tiles that can adjusted to the administrator’s preferences. The bin at the top right can be used to delete tiles whereas the “plus” opens a popup selection list to add tiles. All the tiles have details charts which open on click and reveal more information.

All predefined tiles open a pop up with detailed information on click.

There is a help sections that gives more details for the tiles contents. It can be opened via the information “i” icon at the top right.

The predefined tiles are:

SAC Sessions – overview of live and active SAP Analytics Cloud Sessions that have been established by the logged-on users.

Passive Sessions – overview of current SAC Sessions that have been established by the logged-on users but are not actively used anymore.

Active Users – List of users that are currently logged on to SAP Analytics Cloud with information about their assigned license.

Users Yet To Logon – List of users that have never logged on to SAP Analytics Cloud.

Session Trend – Historic view on user logons, SAP Analytics Cloud sessions and browser sessions that have been opened during user logons.

License Usage Trend – Historic view on all used licenses. On click pops-up a chart with license usage history per license type.

Concurrent Licenses – Real time number of concurrent licenses and the maximum limit. On click pops-up a chart with logon history for users assigned with this license type.

BI Licenses – Assigned Business Intelligence licenses and their maximum limit. On click pops-up a chart with logon history for users assigned with this license type.

Planning Licenses – Assigned Planning Licenses and their maximum limit. On click pops-up a chart with logon history for users assigned with this license type.

Professional Licenses – Assigned Planning Professional Licenses and their maximum limit. On click menu pops-up a chart with logon history for users assigned with this license type.

Top 10 User by Storage – Users by size of their total stored content.

Top 10 Models by Storage – Models by their size.

Search for free search in the repository for objects such as folder, connection, model, dataset, data action, analytic application, story, and insight. Free search for teams, roles and users. The icon opens a specific search pop-up from where you can jump to the respective fact sheet for detailed information about the object, user, role, or team. Fact Sheets will be discussed later.

Search

Content

The structure of the ‘content’ section for all other topics are similar. We start each page at the top with a content summary or key KPIs. This is followed by more granular information that is structured in sections. Each section is, by default, expanded but can also be collapsed. Subsequent sections give access to fact sheets, editor, and overview. After selecting a table entry, each of the three buttons open a new browser tab.

Depending on the object type, fact sheets will have different flavors, which we will discuss later.

For all object types, except user, team, and connection, the editor jumps directly into the maintenance of the selected object.

The overview button directs you to the SAP Analytics Cloud menu entry for the selected object type.

Another common functionality for all tables in the Administration Cockpit is the possibility to export to .csv, .xlsx, and .pdf.

The content summary allows you to gain rapid overview of all objects that have been created within the SAP Analytics Cloud Service.

General and Planning related content sections have the full list of the information per object type.

Authorization

Purpose of the authorization topic is to get the complete picture of role and team assignments, as easily as possible.

Key KPIs show users, teams, roles that are in-use, teams without any user assignment, users that have not logged-on in the past 6 month or more and user accounts that have never been used at all.

The user section displays user IDs by variable filters selectable via the KPI tiles above.

The team section helps to find unused teams and teams that have no role assignment. It also shows the teams’ size.

The role section gives the full list of roles that have been directly assigned to users or teams and their frequency of use.

Note: If you follow best practice, then no users will have a directly assigned role, they will all be assigned via a team. For more details please visit  SAP Analytics Cloud – Security Concepts and Best Practice

Note: The Defined Users KPI may differ from the number of users that you see in SAC > Security > User because we show here also technical users to be complete.

The authorization overview will help you to identify roles that are assigned to users directly. The role’s fact sheet helps you then to identify the users that have this direct role assignment whereas the user’s fact sheet then helps you to identify which roles the user inherits via a team assignment in contrast to the directly assigned roles.

If you are looking for a specific user, team or role to check remember the search functionality on the home tab and enter fact sheets directly.

Security

Security, or the question what has been shared to whom and how?

Key KPIs show the number of shared objects and how often something has been shared with either the delete or share rights.

The shared objects table provides a full list of object names, their description, ID, and full id (concatenating “object type + ID” and is needed for navigational purposes) of the above.

A very common question is: “I have a list of shared objects, but to whom and how have they been shared?”

This question can be answered by the fact sheet’s security section where you’ll find a full access matrix of users and teams that have access. If you are only interested in a specific folder, Story, Analytic Application, etc. you can also use the search functionality from the home tab to navigate to its Fact Sheet directly.

Dependencies

In past, it might have been a tedious task to identify dependencies between objects.

Dependencies in the Administration Cockpit makes this task much easier than before. Key KPIs show how many models, connections, data actions, and all other object types that might have dependents. Additional it shows the number of models and data actions that aren’t in use anymore.

A dependent object is an object that describes the dependency between two other objects. The dependent object ID corresponds to the full object ID. These dependent objects are necessary to determine what objects are dependent upon others.

To answer the business question: “What are the applications and stories that are dependent upon a given analytic model?” The answer is available in a “fact sheet”. The full list of dependent objects is shown, by type.

Usage

What’s used? What’s unused? What’s used most? What are my top contributors? We try to answer many of those questions in the usage section.

There are currently other usage type questions that cannot yet be answered, but we hope to provide this information soon. The types of usage questions currently not possible are: “How many widgets do I have per story or application? What pages do the users navigate to in my stories or applications? What widget types are most used?”

Housekeeping

Housekeeping aims to help you identify application, stories, folder, etc. that are not actively used anymore.

The Key KPIs and the unused resources section is filtered for the timeframe of “current month – 24 months” to “current month – 6 months”.

the oldest accessed objects sections show all objects last access date per object type ascending.

Trace

The trace section shows the know information of SAP Analytics Cloud Menu > System > Monitor > Trace.

We added the error history chart as well as the Top 10 User by errors history chart.

E2E Performance Analysis

This is the embedded view of the SAP Analytics Cloud Performance Analysis Tool. For further details please visit the blog post SAP Analytics Cloud Performance Analysis Tool

Performance Statistics

This is the embedded view of the SAP Analytics Cloud Performance Statistics and Analysis. For further details please visit the blog post SAP Analytics Cloud Performance Statistics and Analysis

Data Action Statistics

This is the embedded view of the SAP Analytics Cloud Data Action Performance Statistics and Analysis. For further details please visit the blog post SAP Analytics Cloud Data Action Performance Statistics and Analysis

 

Fact Sheets

All fact sheets have a similar structure and is explained in this first example of the model fact sheet.

Administration Cockpit | Fact Sheet | Model

The top of the page, the header area contains information of the model ID, name, description, creation date, and owner.

It also offers the possibility to jump to the model editor and the model overview in the SAP Analytics Cloud menu.

Below the header we have (up to) four sections: Overview, security, dependencies and content.

The overview section contains key KPIs, dependents, security and open model history lanes.

The key KPIs Lane

For the Model, this lane shows the number of dependent objects, users and teams that have access to the model, the users that use the models in their stories, applications, data actions, etc., as well as the number of granted delete and share rights on that model.

The dependents Lane

shows a tabular view of name, description, ID, full ID of the dependent objects, its type and subtype, and how many users and/or teams have access.

Note: Subtype of Story itself = (No Value). Analytic Application and Insight will show the respective value ‘APPLICATION’ or ‘INSIGHT’.

The security lane adds, in a tabular view, user ID and team ID to the delete right and share right KPI data.

The open model history lane shows the read access history of the model.

The security section contains a tabular view the access matrix of all users and teams that have access to the model.

The dependencies section contains a tabular view of the name, description, ID, full ID, object type and subtype of the dependent object, as well as how many users and teams have access to it.

The content section contains a list of the content creators for this model. These are the creators of the dependents.

.

Wherever it makes sense, we allow you to jump from the tables to fact sheet, editor, and overview.

 

Administration Cockpit | Fact Sheet | User

Another complex fact sheet is the user fact sheet. It slightly differs from the model fact sheet but follows the same approach.

The header provides information on user ID, first and last name, email contact, license type, display name, current activity status, and last successful connect. There is also the possibility to jump to the user administration page in SAP Analytics Cloud Menu.

 

Below the Header we have four sections: Overview, authorization, security and content.

The overview section contains Key KPIs, Session Trend and Most Read Resources.

 

The key KPIs lane

for the user shows the numbers for the different object types that have been shared with the user, how many roles are direct assigned to the user, how many roles are inherited and how many teams the user is a member of.

The session trend lane

Shows the history of the users SAP Analytics Cloud sessions and browser sessions by day.

The most read resources lane

shows the models, analytic applications, stories, and insights that are used most by the user.

The authorization section contains a tabular view the role assignments, which can be separated in direct assigned and team inherited, and team assignments.

The security section contains a tabular view of the name, description, ID, full ID with access rights that are shared to the user.

The content section contains a list of the content that has been created by the user and how many users and teams have access to it.

Wherever it makes sense, we allow you to jump from the tables to fact sheet, editor and overview.

Administration Cockpit | Fact Sheet | Role

The role fact sheet shows user and team assignments and opens the possibility to jump to the role maintenance directly.

Administration Cockpit | Fact Sheet | Team

The team fact sheet shows user and role assignments and opens the possibility to jump to the team overview directly.

 

The following fact sheets contain the same information and functionality as the Fact Sheet | Model but only overview and security are relevant. Thus, the following fact sheets are less complex. Please see them as a list of reference and for completeness. They should be self-explanatory after the introduction of the model and the user fact sheet. If questions remain, please feel free to post them to this blog post.

Administration Cockpit | Fact Sheet | Analytic Application

Administration Cockpit | Fact Sheet | Story

Administration Cockpit | Fact Sheet | Insight

Administration Cockpit | Fact Sheet | Folder

Administration Cockpit | Fact Sheet | Connection

Administration Cockpit | Fact Sheet | Data Action

Administration Cockpit | Fact Sheet | Dataset

 

We hope you like the new content!

 

Outlook:

  • Improvements in Usage Reporting
    • How many Widgets per Resource
    • Most visited Pages in Resources
    • Models per Connection
    • Models per Resource
    • Widget Types per Resource

 

Assigned Tags

      25 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Josef Hampp
      Josef Hampp

      Great Blog Post!

      Author's profile photo Henry Banks
      Henry Banks

      great stuff Thomas Fery can't wait to try this out with my customers in the new year ! cheers, H

      Author's profile photo Reinier Van Den Berg
      Reinier Van Den Berg

      Awesome !! Cannot wait to have a look at it. We have been waiting for something like this.

      Thanks

      Author's profile photo BW team BW team Nestlé Business Technology
      BW team BW team Nestlé Business Technology

      Thomas Fery Would it be possible with this tool or the underlying models to have a full E2E flow report. IE would it be possible to report the models that are linked to a specific connection (say a BW live connection) the related BW query, and then from the model identify the story and finally whom has the relevant permissions on that story?

      Author's profile photo Thomas Fery
      Thomas Fery
      Blog Post Author

      Hi BW team BW team Nestlé Business Technology

      Yes this is possible with 2022.02!

      In 2022.01 your workflow will be already possible without the Model - BW Query Name mapping but all the other information (Connection > Model > Story > Sharing Settings).

      This piece will be added with 2022.02 and 2022.Q1 QRC.

      Thanks,

      Thomas

      Author's profile photo Daniel SPOKOINYI
      Daniel SPOKOINYI

      Hi Thomas. will the ability to see the only the sharing setting, or also the BW query name: (not very clear from your answer)

       

      Also, would it be possible to search the nother way around - If we have a query, and we would like to check where it is used in SAC (maybe somebody put it in the wrong folder)... Would be a great addition - we also put this on the influence page.

      Business case is that IT wants for example change a query, or delete it, and needs to check if anyone is using that query in SAC.

      Author's profile photo Thomas Fery
      Thomas Fery
      Blog Post Author

      Hi Daniel SPOKOINYI,

      you see both, the query name and the sharing settings for the model. You will be able to check who is using a specific model, but you cannot search for models that use a specific query.

      Best regards,

      Thomas

      Author's profile photo Henry Banks
      Henry Banks

      Hi Thomas Fery

      is there the possibility to 'save as' -> PDF format for this application?

      i can that it is possible to do a recurring publication schedule, but wondering if the cockpit could be enhanced to allow one-time export/snapshot ?

      schedule

      Regards, H

      p.s.  Sandeep Neelam

      Author's profile photo Thomas Fery
      Thomas Fery
      Blog Post Author

      Hi Henry Banks

      could you please set up a meeting with myself and Christina Mast to discuss this?

      Thanks,

      Thomas

      Author's profile photo Galin Manolov
      Galin Manolov

      Should the contents of the "System/Common/SAC Content" folder remain there or can they be moved to another folder? And if moved, will they be automatically updated to the latest version in case of changes?

      Author's profile photo Thomas Fery
      Thomas Fery
      Blog Post Author

      Hi Galin Manolov

      you can move the content, nevertheless I would recommend to leave the original content in the original namespace in the SAC Content Folder. If you want to move or customize the content, you could take a copy and store this in any other location.

      Thanks,

      Thomas

      Author's profile photo Galin Manolov
      Galin Manolov

      Thank you, Thomas!

      Author's profile photo Daniel Spokoinyi
      Daniel Spokoinyi

      what I really miss is the options to filter - at the moment you have neither time filters (To see statistics of last months) nor actually the possibility to check the statistics for a sub part of your SAC tenant (we use the folders in SAC to check by application, or at least teams...) Would make the admin cockpit 100% better. I could add it using the application editor, but then you chance standard content :O Not ideal!

      What do you think? For when is that planned?

      Author's profile photo Thomas Fery
      Thomas Fery
      Blog Post Author

      Hi Daniel Spokoinyi ,

       

      thanks for the feedback. We have this on our list and will come up with a improved version soon. I am going to update the blog with a what's new section then.

      Thanks,

      Best regards,

      Thomas

      Author's profile photo Tulika Rani Shaw
      Tulika Rani Shaw

      Great blog.

       

      Is there any possibility to  see when users have logged in to the SAC web or mobile app.

       

      Regards,

      Tulika

      Author's profile photo BW team BW team Nestlé Business Technology
      BW team BW team Nestlé Business Technology

      Yes I'm interested in this too

       

      Author's profile photo David Hajek
      David Hajek

      Hello,

      could you tell me if is somehow possible to see a user who consume an concurrent license? I found a model "LICENSE" where you can see a limit and used licenses, but there are no usernames. I would like to built my own small story, where I could track current users with this license. Also, sometimes I see different number in "used" measure in "LICENSE" model than in a "Monitor" application where it shows current count of licenses in use.

      Thank you.

      David

      Author's profile photo Martijn van Foeken
      Martijn van Foeken

      Hi Thomas,

      Is there any way to filter the content in the Admin Cockpit based on workspaces? Would be great to zoom in on a workspace to monitor activities!

      Kind regards,

      Martijn van Foeken | Interdobs

      Author's profile photo Martijn van Foeken
      Martijn van Foeken

      Hi Thomas,

      Can you share any updates when you expect we can report on Models per Connection? And even more interesting: which connection is used for import jobs defined in models?

      Kind regards,

      Martijn van Foeken | Interdobs

      Author's profile photo Thomas Fery
      Thomas Fery
      Blog Post Author

      Hi Martijn van Foeken,

      you can answer the first questions already in the Admin Cockpit.

      Go to "Dependencies" for the list of Connections. Select the entry of interest and open the Fact Sheet for it.

       

       

      I will check with Development on the second question and provide an update soon.

      Thanks,

      Thomas

       

      Author's profile photo Martijn van Foeken
      Martijn van Foeken

      Hi Thomas,

      Thanks for your reply! I noticed (and played with) the dependencies tab and the factsheet. Unfortunately all import connections are grouped together as 'SAC'. If you build a model from scratch and import data later, I can imagine there is no dependency with a connection. See also my request to get information on connection used in import jobs.

      The reason why I'm asking is that I have a tenant with connections that do not follow naming convention and they cause problems during transports. I want to remove these connections, but I don't want to disrupt any developments, etc. so I want to know which models have a dependency with an import connection.

      Furthermore, import connection like OData are bound to a specific model so here it would be useful to be able to display this dependency.

      I also played around with the 'usage' models but here no dependencies are captured for models and import connections.

      Any ideas from your side?

      Kind regards,
      Martijn van Foeken | Interdobs

      Author's profile photo Thomas Fery
      Thomas Fery
      Blog Post Author

      Hi Martijn van Foeken,

      thank you for the request. Unfortunately currently it is not possible to get the information you are looking for in the SAC Content. We discuss this soon and I will provide an update asap.

       

      Thanks,

      Thomas

      Author's profile photo Martijn van Foeken
      Martijn van Foeken

      Hi Thomas,

      Thanks for the confirmation. Looking forward to the next update!

      FYI: I have created an improvement request to keep track: 292908 - Apply workspace as filter in SAC Administration Cockpit.

      Kind regards,

      Martijn van Foeken | Interdobs

      Author's profile photo Krishn Kant
      Krishn Kant

      ​Hi

      I need to find the number of users logging into SAC Web browser and Mobile applications and also the report name they are accessing . I could not find the respective objects in any of the page/Model to provide me the required information .Please could you help me on this .Thanks in Advance.

      Regards

      Author's profile photo Thomas Fery
      Thomas Fery
      Blog Post Author

      Hi Krishn Kant,

      thank you for your question. Currently we do not differentiate between mobile and notebook in the used models. Nevertheless, we are already aware of this requirement.

      We will let the community know when this information will be accessible.

      Thank you and best regards,

      Thomas