You create data chapters and add data from different sources into them.
1. In the 2011_xx period and Data Cache_xx report, create several standard Excel chapters that are visible in Disclosure Management. Use the following list of chapter names:
Hint:
To create several chapters without closing and reopening the New chapter window, before you click Add, select the Add and create another chapter checkbox.
● Financial Statements
● Headcounts
● Notes
2. Add and format data into the chapters according to the following table:
Chapter Method to Add Data Data Number Format
Financial Statements Upload existing file Financial Statements.xlsx Headcounts Data entry or
copy-paste
See Headcount table here or file
Headcounts.xlsx
Number, no decimals, thousands separator
Notes Data link to SQL
Server
SQL Server data source (SQLREAD/
training), SQL for training briefing book, DM100_01-subsidiary
Research and development 5984
Sales and marketing 2136
General and administration 4482
2011.DEC
Infrastructure 2590
Table 11: Text Replacement in Notes
Existing Text Text to Enter
entityCode Code of entity
entityName Name of entity
entityCountry Country of incorporation or residence of
entity
entityOwnership Proportion of ownership interest in entity
entityVotes Proportion of voting power in entity
Note:
Here you replace formulas, that retrieve text from the BD1 worksheet, with a custom text. If needed, in the BT sheet, you can enter other content. The existing text is the column name of the SQL query.
3. Insert the data of the data cache chapters into the Insert Data_xx Microsoft Word chapter of the Configuration Testing period and Word Tests report. For each data cache chapter, insert the data of one worksheet as a table.
Chapter Worksheet to Insert
Financial Statements IS
Headcounts Sheet1
Notes BT
Unit 2 Solution 2
Create a Data Cache
You create data chapters and add data from different sources into them.
1. In the 2011_xx period and Data Cache_xx report, create several standard Excel chapters that are visible in Disclosure Management. Use the following list of chapter names:
Hint:
To create several chapters without closing and reopening the New chapter window, before you click Add, select the Add and create another chapter checkbox.
● Financial Statements
● Headcounts
● Notes
a) In the Report functional area, select period 2011_xx and report Data Cache_xx.
b) To create the chapters, repeat the following steps for each chapter of the chapter list.
c) On the General tab page, in the navigation area, select Data Cache_xx.
d) Choose the (Add new chapter) icon.
e) In the Chapter type dropdown list, select Standard.
f) In the Name field, enter the chapter name as mentioned in the chapter list.
g) In the Content type dropdown list, select Microsoft Excel.
h) Select the Visible in Disclosure Management checkbox.
i) Choose Add.
2. Add and format data into the chapters according to the following table:
Chapter Method to Add Data Data Number Format
Financial Statements Upload existing file Financial Statements.xlsx Headcounts Data entry or
copy-paste
See Headcount table here or file
Headcounts.xlsx
Number, no decimals, thousands separator
Chapter Method to Add Data Data Number Format
Notes Data link to SQL
Server
SQL Server data source (SQLREAD/
training), SQL for training briefing book, DM100_01-subsidiary
Research and development 5984
Sales and marketing 2136
General and administration 4482
Infrastructure 2590
Table 11: Text Replacement in Notes
Existing Text Text to Enter
entityCode Code of entity
entityName Name of entity
entityCountry Country of incorporation or residence of
entity
entityOwnership Proportion of ownership interest in entity
entityVotes Proportion of voting power in entity
Note:
Here you replace formulas, that retrieve text from the BD1 worksheet, with a custom text. If needed, in the BT sheet, you can enter other content. The existing text is the column name of the SQL query.
a) In the 2011_xx period and Data Cache_xx report, on the General tab page, select the Financial Statements chapter.
b) On the Upload tab page, choose Browse... and select the Financial Statements.xlsx file.
c) Optionally, enter a comment.
e) In the 2011_xx period and Data Cache_xx report, on the General tab page, select the Headcounts chapter.
f) Choose Edit.
g) Enter the headcounts data or copy and paste them from the Headcounts.xlsx file. Enter the data in the top left corner of the Sheet1 worksheet, that is, enter 2011.DEC in cell B1.
h) Right-click the cells with amounts and choose Format Cells....
i) In the Number tab, choose Number and enter decimal places 0.
j) Select Use 1000 Separator and choose OK.
k) In Microsoft Excel, in the Disclosure Management ribbon tab, choose Apply changes.
l) Optionally, enter a comment.
m) Select Close and choose OK.
n) In the 2011_xx period and Data Cache_xx report, on the General tab page, select the Notes chapter.
o) Choose Edit.
p) In Microsoft Excel, in the Disclosure Management ribbon tab, choose Start.
q) In the Disclosure Management ribbon tab, choose Create datalink.
r) In the Create datalink window, chose New.
s) In the Datasources dropdown list, select SQL Server and choose the (Load BriefingBooks of the selected datasource) icon on the right.
t) In the Connecting with 'SQL Server' window, enter the user SQLREAD and password training and choose OK.
u) In the Load BriefingBook or Query/View dropdown list, select SQL for training and choose the (Load the selected BriefingBook) icon on the right.
v) In the Dataprovider list, select the checkbox of the DM100_01-subsidiary query.
w) Choose OK two times.
x) In the BT worksheet, right-click the cells with amounts and choose Format Cells....
y) In the Number tab, choose Percentage, enter decimal places 0 and choose OK.
z) In the BT worksheet, for column headers, modify the text according to the table.
aa) In Microsoft Excel, in the Disclosure Management ribbon tab, choose Apply changes.
ab) Optionally, enter a comment.
ac) Select Close and choose OK.
Lesson: Creating the Data Cache
3. Insert the data of the data cache chapters into the Insert Data_xx Microsoft Word chapter of the Configuration Testing period and Word Tests report. For each data cache chapter, insert the data of one worksheet as a table.
Chapter Worksheet to Insert
Financial Statements IS
Headcounts Sheet1
Notes BT
a) In the Report functional area, select the Configuration Testing period and the Word Tests report.
b) On the Cockpit tab page, select the Insert Data_xx chapter and choose Edit.
c) In Microsoft Word, in the Disclosure Management ribbon tab, choose Start.
d) In the Disclosure Management ribbon tab, choose Datasources.
e)
In the Datasources (local) window, select DM Data Repository and choose the Connect pushbutton on the right, in the Server area.
f) In the Connecting with 'DM Data Repository' window enter dm-xx and training and choose OK.
g) If needed, in the Datasources (Server: DM Data Repository) window, select DM Data
Repository and choose the Connect pushbutton on the left, in the Connection area.
h) If needed, enter your login and password and choose OK.
i) Choose OK.
j) To insert the data of the chapters, repeat the following steps for each chapter.
k) In the Disclosure Management ribbon tab, choose Table.
l) In the Create datalink window, choose New.
m) In the Datasources dropdown list, select DM Data Repository (Disclosure Management) and choose the (Load Briefingbooks of the selected datasource) icon on the right.
n) In the Load BriefingBook or Query/View dropdown list, select 2011_xx/Data cache_xx/
<chapter name> and choose the (Load the selected BriefingBook) icon on the right.
o) In the Dataprovider list, select the checkbox of the data provider to insert.
p) Choose OK two times.
r) In the Disclosure Management ribbon tab, choose Apply changes.
s) Optionally enter a comment.
t) Select Close and choose OK.
u) Close Microsoft Word.
Lesson: Creating the Data Cache
LESSON SUMMARY You should now be able to:
● Create the data cache