Author Topic: Multiple reports inside a single file...  (Read 5182 times)

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Multiple reports inside a single file...
« on: March 25, 2015, 07:39:55 AM »
I have a strange situation where a customer is generating a half dozen reports, then concatenating them, and transferring them to CMOD to be loaded.  (This is a migration from FileNet Image Services, which apparently used to support this feature.)

Has anyone managed to load this type of file, and still keep the Application definitions intact?  It appears that the reports all have the same format, so it should be possible to re-use the ACIF defintions -- but I'm not sure how to capture the report name and have it populated in the AppID field, so that it's available to the end user as a pop-up menu in the CMOD client (or via ICN).

Any insight would be greatly appreciated.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Frederick Tybalt

  • Full Member
  • ***
  • Posts: 124
    • View Profile
    • Personal Website
Re: Multiple reports inside a single file...
« Reply #1 on: March 26, 2015, 05:17:27 AM »
We had a similar requirement for one of my previous customer, but the report names and count are fixed.

So we captured the report name/ID as one of the index . The report names/IDs are also populated in the Database mapping field so that the report names are listed in the search box and the user can choose the report and do a search.

Hope this helps.
« Last Edit: March 27, 2015, 07:15:43 AM by Frederick Tybalt »
rIcK
======------------------======
www.rick.co.in | www.tekbytz.com

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Multiple reports inside a single file...
« Reply #2 on: March 27, 2015, 05:16:54 AM »
Interesting.  I'll have to play with this.  I think the snag here is that I get the pop-up field that I want, but it's not ACTUALLY using the Application ID field, just a standard index. 

Thanks Fred!
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

ewirtz

  • Full Member
  • ***
  • Posts: 134
    • View Profile
Re: Multiple reports inside a single file...
« Reply #3 on: March 29, 2015, 10:59:38 PM »
Hi Justin,
if you take the report from the indexes you have a new level in in your architecture: application group, application and report. This is OK but you have to look for possible problems p.e. regarding retention management.

regards

Egon

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Multiple reports inside a single file...
« Reply #4 on: March 30, 2015, 04:52:38 AM »
This is OK but you have to look for possible problems p.e. regarding retention management.

Yeah, this is my biggest concern.  I know it CAN be done, now the question is...  Should it be done?  I'll report back with the final decision & rationale.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Alessandro Perucchi

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1002
    • View Profile
Re: Multiple reports inside a single file...
« Reply #5 on: March 30, 2015, 10:45:17 PM »
In that case, in order to have a better control of retention management, to choose an expiration type of "Document" instead of "Load" would be better, so you can choose it per document in case in the future something needs to be defined differently...

not optimal, but maybe that's an alternative.
Alessandro Perucchi

#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML

ewirtz

  • Full Member
  • ***
  • Posts: 134
    • View Profile
Re: Multiple reports inside a single file...
« Reply #6 on: March 31, 2015, 11:02:40 PM »
Hi Alessandro,
as far as I remeber enhanced retention management needs the configuration on load level. By programm holds and releasing them you can install some processes on document level.
Because of special deletion rules like 10 years counting from the end of the year and different retention periods for different reports in the same application, we have done our own retention management.

regards


Egon

Alessandro Perucchi

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1002
    • View Profile
Re: Multiple reports inside a single file...
« Reply #7 on: April 01, 2015, 12:05:51 AM »
Hello Erwitz,

I've never talk about ERM, and in that case you are speaking, yes, you are right.

There are many ways to do retention management.

-> Do it yourself
-> Use the standard tools from CMOD (arsmaint + expiration types)
-> ERM + some custom rules

Each has some positive and negative aspects.

I was just telling Justin, one way to use a standard function of CMOD without relying on ERM... because ERM is a paying function, and sometimes it is not needed... sometimes only :-D

Regards,
Alessandro
Alessandro Perucchi

#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Multiple reports inside a single file...
« Reply #8 on: April 02, 2015, 05:34:22 AM »
Yup, I appreciate any and all input -- I did know about the ERM prerequisite that AGs be configured for load expiration.  :)

Thanks guys! 

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Nolan

  • Full Member
  • ***
  • Posts: 152
    • View Profile
Re: Multiple reports inside a single file...
« Reply #9 on: April 09, 2015, 08:21:55 AM »
We had a similar issue on Z/OS where batches of reports were being sent via one sysout.   

We used two solutions,
1)  We created a proc to split out the output in to different sysouts.  This was updated in the source JCL's to split out the reports using keys from a sysin (not simple but it worked)
2)  We setup a double pass of OnDemand.  First pass we would archive the whole sysout and index on the report ids, then using ODF distribute back to OnDemand individual reports to be archived using specific keys.   Moving the large sysout to tape right away reduced any extra dasd usage.

:)

J.

#zOS #AIX #Windows #Multiplatforms
#DB2 #TSM #ODF #zODF #ODWEK
#CapacityPlanning #AFP #ReportDistribution
#Finance #ICN