Cognos Analytics

​I have not asked this question in a while, maybe someone has an idea or tool for us. One of our most labor intensive production tasks is babysitting cube builds. We are on Cognos 11.0.13, we build our cubes on a Windows server. We can schedule cube builds using the Windows Task Scheduler (time triggers only). However, to know when these finish or fail, someone needs to log on to the server and check the Transformer Logs.

I wonder what other teams are doing to monitor cube builds?

P.S. Yes, we are trying to develop more relational models but for now we have a large number of legacy cubes that we cannot discontinue in the near future.

Any ideas or experiences are welcome! Thanks!

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson

Typically the cube builds that I had setup used scripts, that way I could not only notify someone on complete I would also parse the logs for failures and notify an admin

------------------------------
NORBERT Bracke
------------------------------

Original Message:
Sent: Thu August 22, 2019 01:41 PM
From: Adrienne Beronilla
Subject: Is there a tool to notify my team about completion of cube builds?

​I have not asked this question in a while, maybe someone has an idea or tool for us. One of our most labor intensive production tasks is babysitting cube builds. We are on Cognos 11.0.13, we build our cubes on a Windows server. We can schedule cube builds using the Windows Task Scheduler (time triggers only). However, to know when these finish or fail, someone needs to log on to the server and check the Transformer Logs.

I wonder what other teams are doing to monitor cube builds?

P.S. Yes, we are trying to develop more relational models but for now we have a large number of legacy cubes that we cannot discontinue in the near future.

Any ideas or experiences are welcome! Thanks!

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson

Thanks, I am afraid that my team is not allowed to use scripts but it is something that I will try to explore again. ​

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

Original Message:
Sent: Fri August 23, 2019 08:12 AM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

Typically the cube builds that I had setup used scripts, that way I could not only notify someone on complete I would also parse the logs for failures and notify an admin

------------------------------
NORBERT Bracke

Original Message:
Sent: Thu August 22, 2019 01:41 PM
From: Adrienne Beronilla
Subject: Is there a tool to notify my team about completion of cube builds?

​I have not asked this question in a while, maybe someone has an idea or tool for us. One of our most labor intensive production tasks is babysitting cube builds. We are on Cognos 11.0.13, we build our cubes on a Windows server. We can schedule cube builds using the Windows Task Scheduler (time triggers only). However, to know when these finish or fail, someone needs to log on to the server and check the Transformer Logs.

I wonder what other teams are doing to monitor cube builds?

P.S. Yes, we are trying to develop more relational models but for now we have a large number of legacy cubes that we cannot discontinue in the near future.

Any ideas or experiences are welcome! Thanks!

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson

@NORBERT Bracke​​
Hi Norbert,

would you be able to share a sample of your script?

rich@miamidade.gov
Original Message:
Sent: Fri August 23, 2019 08:12 AM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

Typically the cube builds that I had setup used scripts, that way I could not only notify someone on complete I would also parse the logs for failures and notify an admin

------------------------------
NORBERT Bracke

Original Message:
Sent: Thu August 22, 2019 01:41 PM
From: Adrienne Beronilla
Subject: Is there a tool to notify my team about completion of cube builds?

​I have not asked this question in a while, maybe someone has an idea or tool for us. One of our most labor intensive production tasks is babysitting cube builds. We are on Cognos 11.0.13, we build our cubes on a Windows server. We can schedule cube builds using the Windows Task Scheduler (time triggers only). However, to know when these finish or fail, someone needs to log on to the server and check the Transformer Logs.

I wonder what other teams are doing to monitor cube builds?

P.S. Yes, we are trying to develop more relational models but for now we have a large number of legacy cubes that we cannot discontinue in the near future.

Any ideas or experiences are welcome! Thanks!

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson

I found a few things that might help you: starter bat file: https://www.youtube.com/watch?v=45Fser9fDiY

All Transformer command lines are documented here: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.cogtr.doc/c_clioptionslist.html#CLIOptionsList
 and here https://www.ibm.com/support/knowledgecenter/SSEP7J_10.1.0/com.ibm.swg.im.cognos.ug_cogtr.10.1.0.doc/ug_cogtr_id12029CLIOptionsList.html%23CLIOptionsList

The e-mailing and parsing of the log files is what I am unsure of still but that I think is environment specific and not Transformer related.




​

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

Original Message:
Sent: Fri August 23, 2019 01:14 PM
From: Richard Mabjish
Subject: Is there a tool to notify my team about completion of cube builds?

@NORBERT Bracke​​
Hi Norbert,

would you be able to share a sample of your script?

rich@miamidade.gov
Original Message:
Sent: Fri August 23, 2019 08:12 AM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

Typically the cube builds that I had setup used scripts, that way I could not only notify someone on complete I would also parse the logs for failures and notify an admin

------------------------------
NORBERT Bracke

Original Message:
Sent: Thu August 22, 2019 01:41 PM
From: Adrienne Beronilla
Subject: Is there a tool to notify my team about completion of cube builds?

​I have not asked this question in a while, maybe someone has an idea or tool for us. One of our most labor intensive production tasks is babysitting cube builds. We are on Cognos 11.0.13, we build our cubes on a Windows server. We can schedule cube builds using the Windows Task Scheduler (time triggers only). However, to know when these finish or fail, someone needs to log on to the server and check the Transformer Logs.

I wonder what other teams are doing to monitor cube builds?

P.S. Yes, we are trying to develop more relational models but for now we have a large number of legacy cubes that we cannot discontinue in the near future.

Any ideas or experiences are welcome! Thanks!

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson

you want scripts for Windows or Unix?
I think if you google Cognos transformer batch scripts you should find examples
Many of mine were pretty complex in order to dynamically modify the security using MDL scripting

------------------------------
NORBERT Bracke
------------------------------

Original Message:
Sent: Fri August 23, 2019 01:14 PM
From: Richard Mabjish
Subject: Is there a tool to notify my team about completion of cube builds?

@NORBERT Bracke​​
Hi Norbert,

would you be able to share a sample of your script?

rich@miamidade.gov
Original Message:
Sent: Fri August 23, 2019 08:12 AM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

Typically the cube builds that I had setup used scripts, that way I could not only notify someone on complete I would also parse the logs for failures and notify an admin

------------------------------
NORBERT Bracke

Original Message:
Sent: Thu August 22, 2019 01:41 PM
From: Adrienne Beronilla
Subject: Is there a tool to notify my team about completion of cube builds?

​I have not asked this question in a while, maybe someone has an idea or tool for us. One of our most labor intensive production tasks is babysitting cube builds. We are on Cognos 11.0.13, we build our cubes on a Windows server. We can schedule cube builds using the Windows Task Scheduler (time triggers only). However, to know when these finish or fail, someone needs to log on to the server and check the Transformer Logs.

I wonder what other teams are doing to monitor cube builds?

P.S. Yes, we are trying to develop more relational models but for now we have a large number of legacy cubes that we cannot discontinue in the near future.

Any ideas or experiences are welcome! Thanks!

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson

@NORBERT Bracke​​


For Unix pls.
Original Message:
Sent: Fri August 23, 2019 02:52 PM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

you want scripts for Windows or Unix?
I think if you google Cognos transformer batch scripts you should find examples
Many of mine were pretty complex in order to dynamically modify the security using MDL scripting

------------------------------
NORBERT Bracke

Original Message:
Sent: Fri August 23, 2019 01:14 PM
From: Richard Mabjish
Subject: Is there a tool to notify my team about completion of cube builds?

@NORBERT Bracke​​
Hi Norbert,

would you be able to share a sample of your script?

rich@miamidade.gov
Original Message:
Sent: Fri August 23, 2019 08:12 AM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

Typically the cube builds that I had setup used scripts, that way I could not only notify someone on complete I would also parse the logs for failures and notify an admin

------------------------------
NORBERT Bracke

Original Message:
Sent: Thu August 22, 2019 01:41 PM
From: Adrienne Beronilla
Subject: Is there a tool to notify my team about completion of cube builds?

​I have not asked this question in a while, maybe someone has an idea or tool for us. One of our most labor intensive production tasks is babysitting cube builds. We are on Cognos 11.0.13, we build our cubes on a Windows server. We can schedule cube builds using the Windows Task Scheduler (time triggers only). However, to know when these finish or fail, someone needs to log on to the server and check the Transformer Logs.

I wonder what other teams are doing to monitor cube builds?

P.S. Yes, we are trying to develop more relational models but for now we have a large number of legacy cubes that we cannot discontinue in the near future.

Any ideas or experiences are welcome! Thanks!

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson

These are old but should give you a good start

------------------------------
NORBERT Bracke
------------------------------

Original Message:
Sent: Fri August 23, 2019 03:00 PM
From: Richard Mabjish
Subject: Is there a tool to notify my team about completion of cube builds?


@NORBERT Bracke​​


For Unix pls.
Original Message:
Sent: Fri August 23, 2019 02:52 PM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

you want scripts for Windows or Unix?
I think if you google Cognos transformer batch scripts you should find examples
Many of mine were pretty complex in order to dynamically modify the security using MDL scripting

------------------------------
NORBERT Bracke

Original Message:
Sent: Fri August 23, 2019 01:14 PM
From: Richard Mabjish
Subject: Is there a tool to notify my team about completion of cube builds?

@NORBERT Bracke​​
Hi Norbert,

would you be able to share a sample of your script?

rich@miamidade.gov
Original Message:
Sent: Fri August 23, 2019 08:12 AM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

Typically the cube builds that I had setup used scripts, that way I could not only notify someone on complete I would also parse the logs for failures and notify an admin

------------------------------
NORBERT Bracke

Original Message:
Sent: Thu August 22, 2019 01:41 PM
From: Adrienne Beronilla
Subject: Is there a tool to notify my team about completion of cube builds?

​I have not asked this question in a while, maybe someone has an idea or tool for us. One of our most labor intensive production tasks is babysitting cube builds. We are on Cognos 11.0.13, we build our cubes on a Windows server. We can schedule cube builds using the Windows Task Scheduler (time triggers only). However, to know when these finish or fail, someone needs to log on to the server and check the Transformer Logs.

I wonder what other teams are doing to monitor cube builds?

P.S. Yes, we are trying to develop more relational models but for now we have a large number of legacy cubes that we cannot discontinue in the near future.

Any ideas or experiences are welcome! Thanks!

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson

Thank you @NORBERT Bracke​

I will check it out.
Original Message:
Sent: Mon August 26, 2019 10:28 AM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

These are old but should give you a good start

------------------------------
NORBERT Bracke

Original Message:
Sent: Fri August 23, 2019 03:00 PM
From: Richard Mabjish
Subject: Is there a tool to notify my team about completion of cube builds?


@NORBERT Bracke​​


For Unix pls.
Original Message:
Sent: Fri August 23, 2019 02:52 PM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

you want scripts for Windows or Unix?
I think if you google Cognos transformer batch scripts you should find examples
Many of mine were pretty complex in order to dynamically modify the security using MDL scripting

------------------------------
NORBERT Bracke

Original Message:
Sent: Fri August 23, 2019 01:14 PM
From: Richard Mabjish
Subject: Is there a tool to notify my team about completion of cube builds?

@NORBERT Bracke​​
Hi Norbert,

would you be able to share a sample of your script?

rich@miamidade.gov
Original Message:
Sent: Fri August 23, 2019 08:12 AM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

Typically the cube builds that I had setup used scripts, that way I could not only notify someone on complete I would also parse the logs for failures and notify an admin

------------------------------
NORBERT Bracke

Original Message:
Sent: Thu August 22, 2019 01:41 PM
From: Adrienne Beronilla
Subject: Is there a tool to notify my team about completion of cube builds?

​I have not asked this question in a while, maybe someone has an idea or tool for us. One of our most labor intensive production tasks is babysitting cube builds. We are on Cognos 11.0.13, we build our cubes on a Windows server. We can schedule cube builds using the Windows Task Scheduler (time triggers only). However, to know when these finish or fail, someone needs to log on to the server and check the Transformer Logs.

I wonder what other teams are doing to monitor cube builds?

P.S. Yes, we are trying to develop more relational models but for now we have a large number of legacy cubes that we cannot discontinue in the near future.

Any ideas or experiences are welcome! Thanks!

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson

​Hi @NORBERT Bracke, would you happen to have a Windows script to share perhaps?

Thank you. ​

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

Original Message:
Sent: Fri August 23, 2019 02:52 PM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

you want scripts for Windows or Unix?
I think if you google Cognos transformer batch scripts you should find examples
Many of mine were pretty complex in order to dynamically modify the security using MDL scripting

------------------------------
NORBERT Bracke

Original Message:
Sent: Fri August 23, 2019 01:14 PM
From: Richard Mabjish
Subject: Is there a tool to notify my team about completion of cube builds?

@NORBERT Bracke​​
Hi Norbert,

would you be able to share a sample of your script?

rich@miamidade.gov
Original Message:
Sent: Fri August 23, 2019 08:12 AM
From: NORBERT Bracke
Subject: Is there a tool to notify my team about completion of cube builds?

Typically the cube builds that I had setup used scripts, that way I could not only notify someone on complete I would also parse the logs for failures and notify an admin

------------------------------
NORBERT Bracke

Original Message:
Sent: Thu August 22, 2019 01:41 PM
From: Adrienne Beronilla
Subject: Is there a tool to notify my team about completion of cube builds?

​I have not asked this question in a while, maybe someone has an idea or tool for us. One of our most labor intensive production tasks is babysitting cube builds. We are on Cognos 11.0.13, we build our cubes on a Windows server. We can schedule cube builds using the Windows Task Scheduler (time triggers only). However, to know when these finish or fail, someone needs to log on to the server and check the Transformer Logs.

I wonder what other teams are doing to monitor cube builds?

P.S. Yes, we are trying to develop more relational models but for now we have a large number of legacy cubes that we cannot discontinue in the near future.

Any ideas or experiences are welcome! Thanks!

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson

Would you be able to use Event Studio to send an email when a condition is met? Something like [Date] = [Current Date]

You could also switch it around to send a Notification if that scenario is not met, indicating the cube did not build.

------------------------------
TREVOR COMEAU
------------------------------

Original Message:
Sent: Thu August 22, 2019 01:41 PM
From: Adrienne Beronilla
Subject: Is there a tool to notify my team about completion of cube builds?

​I have not asked this question in a while, maybe someone has an idea or tool for us. One of our most labor intensive production tasks is babysitting cube builds. We are on Cognos 11.0.13, we build our cubes on a Windows server. We can schedule cube builds using the Windows Task Scheduler (time triggers only). However, to know when these finish or fail, someone needs to log on to the server and check the Transformer Logs.

I wonder what other teams are doing to monitor cube builds?

P.S. Yes, we are trying to develop more relational models but for now we have a large number of legacy cubes that we cannot discontinue in the near future.

Any ideas or experiences are welcome! Thanks!

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson

@TREVOR COMEAU, ​that approach did not work that well for dimensional packages and for situations where we build many cubes simultaneously (month-end, quarter-end). I am using that technique for relational packages. The other issue with using Event Studio for this is that the sweeper events need to be scheduled to run very frequently and during heavy reporting times, these get clogged on our reporting servers.

However, I am trying to explore the possibility of some process writing to the database the parsed transformer log details, so I could create database triggers off of that data... database triggers in turn can be used for scheduled Events.

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

Original Message:
Sent: Mon August 26, 2019 10:26 AM
From: TREVOR COMEAU
Subject: Is there a tool to notify my team about completion of cube builds?

Would you be able to use Event Studio to send an email when a condition is met? Something like [Date] = [Current Date]

You could also switch it around to send a Notification if that scenario is not met, indicating the cube did not build.

------------------------------
TREVOR COMEAU

Original Message:
Sent: Thu August 22, 2019 01:41 PM
From: Adrienne Beronilla
Subject: Is there a tool to notify my team about completion of cube builds?

​I have not asked this question in a while, maybe someone has an idea or tool for us. One of our most labor intensive production tasks is babysitting cube builds. We are on Cognos 11.0.13, we build our cubes on a Windows server. We can schedule cube builds using the Windows Task Scheduler (time triggers only). However, to know when these finish or fail, someone needs to log on to the server and check the Transformer Logs.

I wonder what other teams are doing to monitor cube builds?

P.S. Yes, we are trying to develop more relational models but for now we have a large number of legacy cubes that we cannot discontinue in the near future.

Any ideas or experiences are welcome! Thanks!

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson