主页 > 云主机 > > 正文

云服务器_企业网站建设报价_促销

来源:胜利云 发布时间:2022-04-26 11:20 标签:服务器报价网站建设企业促销
浏览:

云服务器_企业网站建设报价_促销

Recently we tried to improve one of our BPC MS Environments integration, using Admin_MakeDim DTSX.

This SSIS allows you to update an existing BPC Dimension from a MS DB Table.

The only prerequisite concerning you have to fulfill is related to the structure of MS Table: is must to reproduce the mbr table structure.

The following sample is designed on a copy of Environment Shell, on Product Dimension (uou can easily reproduce this behaviour in your system).

Product Dimension has just 3 base members in a very simple Hierarchy

In MS SQL you have to create a "staging" table that has to reproduce mbr table structure.

In our case we created mbrProductStaging, as a copy of mbrProduct

Then we copied data and did some simple changes:

a. added a new node (NEW_NODE)

b. added a new basemember (ProductD) connected to mentioned node (NEW_NODE)

c. changed parent of an existing base member (ProductA -> NEW_NODE)

From the EPM Add-In you have to run Admin_MakeDim.dtsx using the staging table (mbrProductStagin, in our case) as source

As a result Product Dimension will be correctly updated, both on Excel and MS SQL side, and reflecting all the changes done in mbrProductStaging table.

From the EPM Add-In Member Selector you can see the new ProductD, the changed ProductA under the NEW_NODE as well:

The only limitation is related to the BPC Admin Excel MemberSheet, that won’t be updated!

Unlucky the XLS Member Sheet won’t reflect such changes, even if MS DB Tables content have been changed!

This can lead to a loss of data, if you try to process mentioned dimension from MemberSheet.

In our case ProductD and NEW_NODE are going to be deleted:

In order to avoid member deletion and not to undo all the changes done by the Admin_MakeDim you have to execute "Export Dimension" task command from BPC Admin, before making any changes. This will create a new XLS/XLSX file for the Dimension with exactly what is in the SQL DB table mbr (in our case mbrProduct MS SQL table)

We asked SAP whether "Export Dimension" command can be included in Admin_MakeDim Task (as a parameter) or created as BPC Task in SSIS.

Unlucky they said the current behaviour is "by product design" and suggested us to post this a new Idea.

So, if you think this is a product limitation to be overcome please add your vote!

,网站服务器租用,物联网工程课程,我的云,物联网架构,软件企业管理
发表评论
验证码: 点击我更换图片

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

热门文章

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

云储存

更多 >
  • <strong>华为云_精品课程网站建设_高性能</strong>
    华为云_精品课程网站建设_高性能

    元素必须具有唯一的id。 创建控件。 需要一些脚本来创建控件并将其放置在特定位置。 var oVBI=newsap.ui.vbm.VBI('someId', { 宽度:600, 高度:620, 插件:f...

  • <strong>负载均衡_湖北服务器_便宜的</strong>
    负载均衡_湖北服务器_便宜的

    在保加利亚,就像在欧盟和世界其他国家一样,现在有两个看似矛盾的问题:青年失业和行业缺乏合格的人才,尤其是像IT这样的高科技行业。这种现象本...

云储存云数据库_sqlserver导入数据库_优惠券
云储存网站空间_西城网站建设_限时特惠
云储存域名交易_武汉云主机_哪个好
云储存香港带宽_php负载均衡_代金券
云储存谷歌云_昆明建设公司网站_价格