主页 > 云主机 > > 正文

大带宽_数据库mysql下载_代金券

来源:胜利云 发布时间:2022-04-11 02:10 标签:数据库带宽MySQL下载代金券
浏览:

大带宽_数据库mysql下载_代金券

Introduction

This document covers the approach of passing scope/prompt from SAP BPC data manager package to SQL Server stored procedure. This applies to all versions of SAP BPC Version for Microsoft. This approach can be used as an alternate to the approach specified in my earlier document on How to Pass Parameters to SSIS package.

The business case is to pass the parameters from SAP BPC data manager package to a stored procedure.  The BPC users will pass the scope (selections) via the data manager prompts. This selection will be passed to a stored procedure via the data manager package. The stored procedure will receive the scope(selections) from BPC data manager package and store it to a table.

BPC model with the following structure

Environment Name: BADSHELL

Model Name: Planning

Step 1: Create a scope table to receive the scope (selections) passed from SQL Server. This table will be used to receive the parameters passed from the BPC data manager package.  Execute the following script in the SQL Server side.

USE [BADSHELL]

GO

CREATE TABLE [DBO].[BPC_SCOPE](

[SCOPETBL] [NVARCHAR](100) NULL,

[DIMENSION] [NVARCHAR](32) NULL,

[MEMBER] [NVARCHAR](32) NULL

) ON [PRIMARY]

GO

Step 2: Create stored procedure. This stored procedure will receive the selection from BPC and store it in a table (BPC_SCOPE). This table can be used in the further operations like a filter table. To facilitate parallel call of the data manager package this table (BPC_SCOPE) should always be used with the filter SCOPETBL = @SCOPETABLE.

Execute the following script in the SQL Server side. Please read the comments and insert your code…

USE [BADSHELL]

GO

CREATE PROCEDURE [DBO].[USP_CALC_BLOG]

(

@SCOPETABLE VARCHAR(50)

)

AS

BEGIN

EXEC(‘INSERT INTO [BPC_SCOPE] SELECT "’ + @SCOPETABLE + "’, DIMENSION, MEMBER FROM ‘ + @SCOPETABLE)

/*

INSERT YOUR CODE HERE, YOU CAN USE THE BPC_SCOPE TABLE TO FILTER RECORDS

TO MAKE SURE WE ISOLATE CONCURRENT EXECUTION USE THE VARIABLE  @SCOPETABLE

TO FILTER BPC_SCOPE TABLE.

*/

/*

FINALLY YOU CAN DELETE ALL THE RECORDS IN THE BPC_SCOPE TABLE

DELETE FROM BPC_SCOPE WHERE SCOPETBL = @SCOPETABLE

*/

END

Step 3: Create BPC script logic to call the stored procedure. %SCOPETABLE% variable passes the parameter table to the stored procedure.

Step 4: Create data manager package to invoke the script logic

On the web server side, copy the standard "Default Formulas" data manager package (BLOG_10)

Configure the package in the data manager interface in EPM add-in for excel. Go to Data Manager >> Organize package list >> Add package and select the copied package

Modify the package and add the following by specifying following script

Step 5:  Execute data manager package by selecting prompts

Step 6:  Check the results

How to pass a custom parameter to Data Manager Package

SAP BPC MS: Passing Data Manager Selection (Scope) to SSIS Package

It was really great explanation...

Thank you!..

Thanks

Great job, keep it coming!

,大数据存储技术,大数据网,海淘返利,软件企业条件,bi大数据
发表评论
验证码: 点击我更换图片

注:网友评论仅供其表达个人看法,并不代表本站立场。

热门文章

  • 域名备案_阿里云销售顾问_最新活动
    <strong>域名备案_阿里云销售顾问_最新活动</strong>

    域名备案_阿里云销售顾问_最新活动

    高速互联网和功能强大的应用程序使得几乎所有有办公桌工作的人都可以在家工作。然而今天,大多数公司仍然坚持要求员工忍受有时令人心碎的上下班路...

  • 数据库_分布式消息中间件实践pdf_免费领
    <strong>数据库_分布式消息中间件实践pdf_免费领</strong>

    数据库_分布式消息中间件实践pdf_免费领

    作者:马库斯·瓦纳关于2017年趋势的讨论正在迅速而激烈地展开,职场也不例外。随着新的一年即将到来,职场趋势专家们正在为2017年列出自己的预测清单...

  • 域名注册_自考数据库_免费6个月
    <strong>域名注册_自考数据库_免费6个月</strong>

    域名注册_自考数据库_免费6个月

    正如Facebook和Twitter首席运营官(COO)上周在美国国会作证时所说,出现的一个突出主题是,这些公司在保护其平台免受网络攻击方面所扮演的角色。这些公...

  • 域名解析_阿里云是什么意思_怎么买
    <strong>域名解析_阿里云是什么意思_怎么买</strong>

    域名解析_阿里云是什么意思_怎么买

    类别工作日新闻与文化财务人力资源规划技术创新分析与见解客户和社区行业金融服务政府保健高等教育款待媒体和娱乐专业和商业服务零售技术更多播客...

  • 网站服务器_王者荣耀服务器未响应_限时
    网站服务器_王者荣耀服务器未响应_限时

    网站服务器_王者荣耀服务器未响应_限时

    日本甲骨文公司今天宣布,ISOU项目采用甲骨文区块链平台管理一种本币的发行和消费。日本甲骨文公司是ISOU项目的支持公司,该项目旨在解决人口稀少地...

云储存

更多 >
  • <strong>专属服务器_快速建设网站_免费申请</strong>
    专属服务器_快速建设网站_免费申请

    要在创建服务订单时默认总账账户,我们需要遵循以下配置 1。在T代码OMSF中创建服务物料组。 2。使用T代码OMSK创建估价类,然后链接到服务的账户类别参...

  • <strong>负载均衡_多线云主机_精选特惠</strong>
    负载均衡_多线云主机_精选特惠

    配置利息计算程序 此配置允许您对过期的客户帐户收取利息。利息可以使用行项目或总帐户余额计算。SAP跟踪上次计息的日期,并将其存储在客户主记录中...

云储存阿里云_网址域名注册_0元
云储存专属服务器_连接mysql数据库的工具_返利
云储存服务器_gpu云服务器太贵_排行榜
云储存服务器_数据库管理系统_好用
云储存文件存储_头文字d粤语百度云_怎么买