SAP CRM BW Report的工作原理分析

2023-10-19 13:59

本文主要是介绍SAP CRM BW Report的工作原理分析,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

Keys->Content Assist, 默认是Shift + Tab:

Guys,
we don’t need to remember all possible values for a given annotation, just use Ctrl+space or your customized hot key to trigger auto completion, just as the same way you did in SAP GUI:

CRM Interactive (OLTP) Reporting: very old stuff started in 2006 with CRM 5.2.
With this approach, no separate SAP BI system was required for basic operational / transactional CRM reporting. Instead, the SAP NetWeaver stack that comes with SAP CRM could be used in order to run real-time operational CRM reports directly on the CRM implementation.

Prerequisites

You have set up a client for processing BI Content in SAP CRM. This can be the same client as the one that contains the data for report creation.
The data displayed in an interactive report depends on the user’s position within the organizational model. For example, the reports of a sales employee only contain data for opportunities for which he or she is responsible. However, a manager can see data for all opportunities for which the sales employees in the manager’s organizational unit are responsible.

Report Areas for Interactive Reports Based on SAP HANA VDM

How it works

When you make some related fields in CRM and save, FM CRM_UPLOAD_BW will be called:

check this structure: BAD_BUS_TRANSN_MESSAGE
and this FM: /1CRMGC/BUS_TRANS_MSG_BWA ( constant of site id defined there )
table SMOXSTAT: defintion for all data sources table SMOXRELP_S: definition of fields for datasource…
important mapper: CRM_BW_SERVPRO_H_MAP
This mapper is called before data is sent to BW.

Read

In read scenario, why destination is QDD?!

0CRM_SRV_PROCESS_H or /CRMBW/OLTP_SRV_ORDER?




outbound BW destination: table roosprmsf
tcode RSA2, DS name: 0CRM_SRV_PROCESS_H

Jerry founds two different kinds of Data source in tcode RSA5 !!


Jerry assumption: one of them is for BW report, and the other is for CRM Interactive Report
table for Interactive report destination: rslogsysdest
relationship between data source and query?

tcode RSRTQ, query name: /CRMBW/SVO_C01_Q0001:

How number of Open Service Order is modelled in BW report:


It works but how? Debug RSOA_DSOURCE_READ_REMOTE_DATA.

index table? CRMD_DHR_HSRVORD
Strange! the order created by report CRM_ORDER_CREATE_SRVO is not put into that table, but if I create order in WebUI, the corresponding entry is in that table. Why?
I made a lot of trace trying to figure out who has filled this buffer table under the hood for us?
I found an intresting tcode CRMD_FILL_CACHE 😃
and tcode for One order document mass creation: CRMD_1O_MC
Check customizing in CRM Analytics->Interactive Reporting->Cache management
2268061 - The table CRMD_DHR_ISRVORD is empty #SAPCRM

this report: CRM_REPORT_CACHE_STAT

note 2090500 - Transaction CRMD_FILL_CACHE not filling all entries into cache tables
The buffer tables are used only for interactive reporting and not by any other application. We need not fill the buffer tables explicitly with the data, The required data gets filled at run time as and when you execute the interactive reports. The buffer tables are supposed to have only the required data and not the whole data that is present in the document tables, then there will be no point for having seperate buffer tables , we can as well fetch it from document tables.
The maximum amount of entries for a cache table can be seen in the customizing table CRMC_Q1O_CACHE.

要获取更多Jerry的原创文章,请关注公众号"汪子熙":

这篇关于SAP CRM BW Report的工作原理分析的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/240260

相关文章

性能分析之MySQL索引实战案例

文章目录 一、前言二、准备三、MySQL索引优化四、MySQL 索引知识回顾五、总结 一、前言 在上一讲性能工具之 JProfiler 简单登录案例分析实战中已经发现SQL没有建立索引问题,本文将一起从代码层去分析为什么没有建立索引? 开源ERP项目地址:https://gitee.com/jishenghua/JSH_ERP 二、准备 打开IDEA找到登录请求资源路径位置

深入探索协同过滤:从原理到推荐模块案例

文章目录 前言一、协同过滤1. 基于用户的协同过滤(UserCF)2. 基于物品的协同过滤(ItemCF)3. 相似度计算方法 二、相似度计算方法1. 欧氏距离2. 皮尔逊相关系数3. 杰卡德相似系数4. 余弦相似度 三、推荐模块案例1.基于文章的协同过滤推荐功能2.基于用户的协同过滤推荐功能 前言     在信息过载的时代,推荐系统成为连接用户与内容的桥梁。本文聚焦于

hdu4407(容斥原理)

题意:给一串数字1,2,......n,两个操作:1、修改第k个数字,2、查询区间[l,r]中与n互质的数之和。 解题思路:咱一看,像线段树,但是如果用线段树做,那么每个区间一定要记录所有的素因子,这样会超内存。然后我就做不来了。后来看了题解,原来是用容斥原理来做的。还记得这道题目吗?求区间[1,r]中与p互质的数的个数,如果不会的话就先去做那题吧。现在这题是求区间[l,r]中与n互质的数的和

SWAP作物生长模型安装教程、数据制备、敏感性分析、气候变化影响、R模型敏感性分析与贝叶斯优化、Fortran源代码分析、气候数据降尺度与变化影响分析

查看原文>>>全流程SWAP农业模型数据制备、敏感性分析及气候变化影响实践技术应用 SWAP模型是由荷兰瓦赫宁根大学开发的先进农作物模型,它综合考虑了土壤-水分-大气以及植被间的相互作用;是一种描述作物生长过程的一种机理性作物生长模型。它不但运用Richard方程,使其能够精确的模拟土壤中水分的运动,而且耦合了WOFOST作物模型使作物的生长描述更为科学。 本文让更多的科研人员和农业工作者

MOLE 2.5 分析分子通道和孔隙

软件介绍 生物大分子通道和孔隙在生物学中发挥着重要作用,例如在分子识别和酶底物特异性方面。 我们介绍了一种名为 MOLE 2.5 的高级软件工具,该工具旨在分析分子通道和孔隙。 与其他可用软件工具的基准测试表明,MOLE 2.5 相比更快、更强大、功能更丰富。作为一项新功能,MOLE 2.5 可以估算已识别通道的物理化学性质。 软件下载 https://pan.quark.cn/s/57

衡石分析平台使用手册-单机安装及启动

单机安装及启动​ 本文讲述如何在单机环境下进行 HENGSHI SENSE 安装的操作过程。 在安装前请确认网络环境,如果是隔离环境,无法连接互联网时,请先按照 离线环境安装依赖的指导进行依赖包的安装,然后按照本文的指导继续操作。如果网络环境可以连接互联网,请直接按照本文的指导进行安装。 准备工作​ 请参考安装环境文档准备安装环境。 配置用户与安装目录。 在操作前请检查您是否有 sud

hdu4407容斥原理

题意: 有一个元素为 1~n 的数列{An},有2种操作(1000次): 1、求某段区间 [a,b] 中与 p 互质的数的和。 2、将数列中某个位置元素的值改变。 import java.io.BufferedInputStream;import java.io.BufferedReader;import java.io.IOException;import java.io.Inpu

hdu4059容斥原理

求1-n中与n互质的数的4次方之和 import java.io.BufferedInputStream;import java.io.BufferedReader;import java.io.IOException;import java.io.InputStream;import java.io.InputStreamReader;import java.io.PrintWrit

线性因子模型 - 独立分量分析(ICA)篇

序言 线性因子模型是数据分析与机器学习中的一类重要模型,它们通过引入潜变量( latent variables \text{latent variables} latent variables)来更好地表征数据。其中,独立分量分析( ICA \text{ICA} ICA)作为线性因子模型的一种,以其独特的视角和广泛的应用领域而备受关注。 ICA \text{ICA} ICA旨在将观察到的复杂信号

工作常用指令与快捷键

Git提交代码 git fetch  git add .  git commit -m “desc”  git pull  git push Git查看当前分支 git symbolic-ref --short -q HEAD Git创建新的分支并切换 git checkout -b XXXXXXXXXXXXXX git push origin XXXXXXXXXXXXXX