cancel
Showing results for 
Search instead for 
Did you mean: 

Create new report/period in SAP Disclosure Management (manually or using roll foward)

Felipe_Barbosa
Explorer
0 Kudos
384

I have to build a report (datacache/word) for the Group and 50 other companies in the group. The structures of both are very similar (datacache/word), apart from some notes and the data that the datacache must present from each one.
I thought of two alternatives:
1- create the main one (group - datacache/word) and then copy both to new ones (datacache/word) that would use each company (unit), which would help with the profile, but I would have to manually replace each datalink in the word chapter (200 tables each one 50 company) because they would have a link to a different datacache.
2- use the roll forward function and create a specific period for each company (2024_EMP100, 2024_EMP200, etc.), so there would be no need to replace all the datalinks in the word chapters, as the roll forward would do this.
Please, what would be the most appropriate/recommended thing to do, or would I have another option?

Thanks,

Felipe

SAP Disclosure Management @Olga_Vasileva @Marc_Kuipers  

View Entire Topic
Olga_Vasileva
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi @Felipe_Barbosa , 
Depending who you want entity reports to be shown - as Period objects or as Report objects - would define how you should proceed. Access can be managed in both cases, and I've seen customers using either.

A couple of important notes for you:
1) you can do mass update of datalink source in a single report using "Change datalink" feature in Content Refresh on report level - change one datalink manually, and then do a mass change for the rest.
2) you can simplify report copying by appointing the first report as Template and creating reports from template per business units created: https://help.sap.com/docs/SAP_DISCLOSURE_MANAGEMENT/6fda503523d6413597f5cd81be59fa8a/8457c6766d5b101...

Felipe_Barbosa
Explorer
0 Kudos

Hi @Olga_Vasileva 

Thanks for your aswear.

I have doubts about your comments. I have these reports (Datacache and word), and I going to replicate this for 50 company.

One solution, is use roll forward and change the period name, using composed period (period+company code), ex. 2023-100, Q1 2023-100, 2023-200, Q1 2023-200, because the key is period+report. With this, the name of report (word/datacache) is always the same.

1 - About your first suggestion. Today I have:

Datacache:

Felipe_Barbosa_0-1718197607702.png

Word:

Felipe_Barbosa_1-1718197625124.png

I have in word several chapter that has tables (datacache) with datalinks/briefingbooks, each one with a key compose period+datacache+table in a Datasource.

Felipe_Barbosa_19-1718197676520.png

When a use Change datalink, it was change Datasource and period, but not the name of datacache (report “Datos Fuente Recelacion…”), correct?

Felipe_Barbosa_20-1718197720728.png

And for me, I need create in this case word and Excel (datacache) with a diffent names (50 companies), because is not possibly create with a same name of period/report. So, if I copy word and datacache archive for another company in the same period, I need change name of report (Word/Datacache) or name of period, because they is a key.

Felipe_Barbosa_21-1718197743384.png

2 - About your second suggestion:

How do I enable one report to become a template for another? When I try to create a new one as a template, there is no report to use as a template. In the report that would be the template, the option is disabled.

Felipe_Barbosa_22-1718197803337.png

And when I try to create it as a template, no option appears.

Felipe_Barbosa_23-1718197822830.png

Or I have a first option that I explain in the begin of this post:

  • create the main one (group - datacache/word) and then copy both to new ones (datacache/word) that would use each company (unit), which would help with the profile, but I would have to manually replace each datalink in the word chapter (200 tables each one 50 company) because they would have a link to a different datacache.

I appreciate your comments.

Tks,

Felipe B.

0 Kudos

Would it be an option to put Word and Excel in one report ? Because than you can use the template option together with entities.

Than the other problem will be solved automatically.

Felipe_Barbosa
Explorer
0 Kudos

Hi @guido_nachtigall 

I think explain wrong, this is a word (report with table datalinks) and an excel datacache, not a report in excel.

Tks,

Felipe

0 Kudos
Hi Felipe,Let’s schedule a meeting. My calendar is open.
Felipe_Barbosa
Explorer
0 Kudos

Hi @guido_nachtigall,

Thank you for your time. Send me an email and we'll set up a meeting.

felipeand@hotmail.com

Regards,

Felipe B.

Felipe_Barbosa
Explorer
0 Kudos

Hi @guido_nachtigall,

Thank you a lot for you time and help at call. I tested the both options and both works well.

1 - Use roll foward and in new period put "concatenate period+company code".

2 - Create two report (datacache and word) in same one and use create report from template (manage report options).

Below I details the second one: Create two report

1- Create report types:

Felipe_Barbosa_0-1718820940290.png

 

Felipe_Barbosa_1-1718820940295.png

 

Felipe_Barbosa_2-1718820940300.png

 

Felipe_Barbosa_3-1718820940303.png

2- Create a report and check with template:

Felipe_Barbosa_4-1718820940311.png

3- Assigned entity to “Group”, and check field “Template for Entities”:

Felipe_Barbosa_5-1718820940316.png

4- Create two chapter (type without content) Datacache and Word:

Felipe_Barbosa_6-1718820940321.png

5- Below chapter Datacache, I created one chapter type standard (Tabela 1) Microsoft Excel with available as datasource (here it had behavior of datacache, correct?):

Felipe_Barbosa_7-1718820940328.png

6- Below chapter Word, I created one chapter type standard (Capitulo 1) Microsoft Word.

Felipe_Barbosa_8-1718820940334.png

7- Create a table inside chapter “Tabela 1“ (datacache behavior).

Felipe_Barbosa_9-1718820940337.png

8- And create a table datalink in word chapter “Capitulo 1” with chapter “Tabela 1” (datacache).

Felipe_Barbosa_10-1718820940349.png

9- I create a new report in "manage reports" using “New from template”, select period and report base and what entity I would like to copy.

Felipe_Barbosa_11-1718820940353.png

10- New report creates:

Felipe_Barbosa_12-1718820940364.png

11- The news reports has the same structure and the name in datalink is correct (Q1 2022/All100/Tabela1):

Felipe_Barbosa_13-1718820940371.png