skills.rest
arc-mcp
arc-mcpOFFICIAL
Explore all skills by this author →
GitHub

generate-cds-analytical-query

Generate analytical CDS queries as transient projection views from SAP cubes.

156|39|Updated Mar 25, 2026
Search Tags:#Automation#cube#SAP#analytical query#CDS
One-click install
npx skills add https://github.com/arc-mcp/arc-1 --skill generate-cds-analytical-query
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: generate-cds-analytical-query
Source: https://github.com/arc-mcp/arc-1/tree/main/skills/generate-cds-analytical-query
Command: npx skills add https://github.com/arc-mcp/arc-1 --skill generate-cds-analytical-query

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill automates the creation of analytical CDS queries based on existing SAP cubes, reducing the manual effort required for generating complex queries.

Core Features & Use Cases

  • Automated Query Generation: Automatically generates CDS analytical queries for end users to consume in analytical clients.
  • Cube Projection: Projects views onto cubes, enabling analytics on the data.
  • Use Case: A developer needs to expose an analytical cube for analysis. Instead of manually creating the CDS view, they use this skill to generate it programmatically.

Quick Start

Generate a CDS analytical query for the cube 'ZI_Sales_Cube' using the skill 'generate-cds-analytical-query'.

Frequently Asked Questions about generate-cds-analytical-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a CDS analytical query from an SAP cube?▼

To generate a CDS analytical query from an SAP cube, use an automation skill that creates transient projection views with the PROVIDER CONTRACT ANALYTICAL_QUERY annotation, projecting the underlying cube for analytical consumption.

What is a transient projection view with PROVIDER CONTRACT ANALYTICAL_QUERY?▼

A transient projection view with PROVIDER CONTRACT ANALYTICAL_QUERY is a CDS entity that projects an SAP cube to expose its data for consumption in analytical clients like SAP Analytics Cloud.

Do I need a specific SAP_BASIS version to create analytical CDS queries?▼

Yes, creating analytical CDS queries with this automated approach requires an SAP_BASIS version of 7.57 or higher, along with existing cube access to generate the projection views.

Does automating CDS analytical query generation work with SAP Analytics Cloud?▼

Automating CDS analytical query generation targets analytical clients like SAP Analytics Cloud by programmatically creating the necessary CDS views to expose your SAP cubes for analysis.

Why manually create CDS views for SAP cubes instead of automating the process?▼

Manually creating CDS views for SAP cubes requires significant effort for complex queries, whereas automating the generation process reduces this manual workload and programmatically projects views onto cubes.

Related Skills

Explore More Software Engineering Skills→
arc-mcparc-mcp
156

generate-analytics-star-schema

Generate CDS analytical star schemas from RAP business objects and DDIC tables.

Official
Advanced
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
DayronDLRDayronDLR
3

sap-abap-cds

Provide reference material for SAP ABAP CDS view development and data modeling.

Community
Advanced
likweitanlikweitan
49

cds-view-entities

Define ABAP CDS view entities with v2 syntax for RAP and analytics.

Community
Advanced