选项卡 1. 打开数据集并预览

（注意：分析应用程序的界面包含 2 个部分，使用 Tab Strip 小部件在逻辑上分为 2 个选项卡）

打开数据集和预览数据选项卡

注意：在这个界面中，我们有数据预览选项卡和一个执行打开数据集选择对话框的按钮

选项卡 2. 将数据从预览数据表复制到计划模型表

当我们点击按钮 Next 时，将会显示预览界面。这里我们需要点击加载按钮。在预览表 tblPreview 中的数据将逐条被复制到结果表 tblResult 中。之后，我们可以查看数据，在表格​​中对其进行编辑，并使用标准 SAP 分析云 界面发布或还原数据。

结果预览和发布/还原选项卡

// Open dataset / model dialog to allow user to select the required source dataset

tblPreview.openSelectModelDialog();

// Making all dataset dimensions visible in the table

var dimList = tblPreview.getDataSource().getDimensions();

for (var i=0; i< dimList.length; i++)

{

tblPreview.addDimensionToRows(dimList[i],i);

}

// Making Date hierarchy flat, as by default it opens YQM

tblPreview.getDataSource().setHierarchy(“Date”,”@FlatHierarchy”);

// Showing preview table with dataset data

tblPreview.setVisible(true);

// Populating values from dataset into arrays for applying them as filters for the target table

var rsData = tblPreview.getDataSource().getResultSet();

var accMembers = ArrayUtils.create(Type.string);

var ccMembers = ArrayUtils.create(Type.string);

var dsMembers = ArrayUtils.create(Type.string);

var dateMembers = ArrayUtils.create(Type.string);

var baMembers = ArrayUtils.create(Type.string);

// Going through all records of dataset and assigning values to arrays

for (var k=0; k< rsData.length; k++)

{

accMembers[k] = “[Account].[parentId].&[” + rsData[k][“Account”].id + “]”;

ccMembers[k]= “[Cost_center].[CC_H].&[“+  rsData[k][“Cost_Center”].id  + “]”;

dsMembers[k] = “Input”;

dateMembers[k] = rsData[k][“Date”].id.substring(0,4)+rsData[k][“Date”].id.substring(5,7);

baMembers[k] = rsData[k][“Business_Area”].id;

}

// Setting filters of Result table on the second page to show only relevant PoV

tblResult.getDataSource().setDimensionFilter(“Account”,accMembers);

tblResult.getDataSource().setDimensionFilter(“Cost_center”,ccMembers);

tblResult.getDataSource().setDimensionFilter(“Data_source”,dsMembers);

tblResult.getDataSource().setDimensionFilter(“Date”,dateMembers);

tblResult.getDataSource().setDimensionFilter(“Business_Area”,baMembers);

// Showing result table with applied filters

tblResult.setVisible(true);

// Copy lines & submit

// Get set of data from preview table with loaded dataset

var rsData = tblPreview.getDataSource().getResultSet();

// One by one copy values from source table into result (target) table

for (var i=0; i< tblPreview.getRowCount(); i++)

{

// Logic to read records from source table and enter into the target table

// Reading values of Account and Cost center and adjusting to include hierarchy elements

// In case needed, the code can be enhanced with dynamic hier

var Account = “[Account].[parentId].&[” + rsData[i][“Account”].id + “]” ;

var CostCenter = “[Cost_center].[CC_H].&[“+  rsData[i][“Cost_Center”].id  + “]”;

// Writing values into target table with planning model

tblResult.getPlanning().setUserInput({

“Account”:Account,

“Business_Area”:rsData[i][“Business_Area”].id, // Business Area dimension

“Data_source”:”Input”,    // Hardcoded for simplicity. In case needed, logic is the same as Account and Cost center

“Version”:”public.Actual”, // Hardcoded for simplicity. In case needed, logic is the same as Account and Cost center

“Date”:rsData[i][“Date”].id.substring(0,4)+rsData[i][“Date”].id.substring(5,7), // Date dimension

“Cost_center”:CostCenter,

[Alias.MeasureDimension]:”SignedData”},rsData[i][Alias.MeasureDimension].rawValue); // Value

}

// Submitting the data to show it in table

tblResult.getPlanning().submitData();

// Forming Accounts array

var arrDestAcctMembers = ArrayUtils.create(Type.MemberInfo);

arrDestAcctMembers = tblResult.getDataSource().getMembers(“Account”);

var strDestAcctMembers = ArrayUtils.create(Type.string);

for (k=0; k< arrDestAcctMembers.length; k++)

{

strDestAcctMembers[k] = arrDestAcctMembers[k].id;

}

// Forming Cost Centers array

var arrDestCCtMembers = ArrayUtils.create(Type.MemberInfo);

arrDestCCtMembers = tblResult.getDataSource().getMembers(“Cost_center”);

var strDestCCtMembers = ArrayUtils.create(Type.string);

for (k=0; k< arrDestCCtMembers.length; k++)

{

strDestCCtMembers[k] = arrDestCCtMembers[k].id;

}

// Account / Cost centers check check

for (k=0; k< rsData.length; k++)

{

if (strDestAcctMembers.indexOf(“[Account].[parentId].&[” + rsData[k][“Account”].id + “]”) === -1)

{

lbLog.addItem(“A”+k.toString(), “Account ” +  rsData[k][“Account”].id  + ” does not exist in target model”);

}

if (strDestCCtMembers.indexOf(“[Cost_center].[CC_H].&[“+  rsData[k][“Cost_Center”].id  + “]”) === -1)

{

lbLog.addItem(“C”+k.toString(), “Cost center ” +  rsData[k][“Cost_Center”].id  + ” does not exist in target model”);

}

}

lbLog.addItem(“done”, “Dataset check completed”);

lbLog.setVisible(true);