Well, I see in my infinite computer skills while editing I must have deleted a paragraph or two so let me fill in the gap.

The Problem:  I make my filter on the work order screen.   -- Go to Create Report  - Preview Report - and can easily then Export Date into a csv file to manipulate the data.  Easy enough.  But if I go to the Content tab and add any field that turns the report into a "Detailed Report"  and then try to go through the process of Exporting Data, any of the fields that turn the report into a Detailed Report will not be in the same Data Set for exporting all of the data together.  

For instance, I wanted to add the "Craft" field to my report data from the "Planned Labor" category.  It turns the report into a Detailed Report and then keeps the Craft field separate when trying to export all my data.  As example, I  had 52 records in my filter....and Exporting Data mad 52 separate Data Sets just for each record for this craft field.  

This would be the same problem for many other report I would want.  For instance Downtime to include Regular Hours from the Actual Labor category would cause the same issue.  

Not sure what I am doing wrong or if it is a limitation...

Is it possible that someone might know and could just tell me what I am looking to do - Is it possible or am I barking up the wrong tree?

Also, I am new to Maximo.  I keep seeing posts on Cognos.  Is this something that is an add on that needs to be purchased?  Nobody here at our company has heard of it.  Perhaps this "program" will allow me to do what I am looking to do?

Well, I see in my infinite computer skills while editing I must have deleted a paragraph or two so let me fill in the gap.

The Problem:  I make my filter on the work order screen.   -- Go to Create Report  - Preview Report - and can easily then Export Date into a csv file to manipulate the data.  Easy enough.  But if I go to the Content tab and add any field that turns the report into a "Detailed Report"  and then try to go through the process of Exporting Data, any of the fields that turn the report into a Detailed Report will not be in the same Data Set for exporting all of the data together.  

For instance, I wanted to add the "Craft" field to my report data from the "Planned Labor" category.  It turns the report into a Detailed Report and then keeps the Craft field separate when trying to export all my data.  As example, I  had 52 records in my filter....and Exporting Data mad 52 separate Data Sets just for each record for this craft field.  

This would be the same problem for many other report I would want.  For instance Downtime to include Regular Hours from the Actual Labor category would cause the same issue.  

Not sure what I am doing wrong or if it is a limitation...

Hello Barry,  I didn't saw any answer to my previous post.  Is your question still  pending ?

Best regards

------------------------------
Nicolas DESCAMPS
Cognos Expert with Maximo knowledge

------------------------------


Original Message:
Sent: Tue August 08, 2023 06:36 AM
From: Barry Londrigan
Subject: Exporting Data in Ad Hoc Report difficulty

Is it possible that someone might know and could just tell me what I am looking to do - Is it possible or am I barking up the wrong tree?

Also, I am new to Maximo.  I keep seeing posts on Cognos.  Is this something that is an add on that needs to be purchased?  Nobody here at our company has heard of it.  Perhaps this "program" will allow me to do what I am looking to do?

Well, I see in my infinite computer skills while editing I must have deleted a paragraph or two so let me fill in the gap.

The Problem:  I make my filter on the work order screen.   -- Go to Create Report  - Preview Report - and can easily then Export Date into a csv file to manipulate the data.  Easy enough.  But if I go to the Content tab and add any field that turns the report into a "Detailed Report"  and then try to go through the process of Exporting Data, any of the fields that turn the report into a Detailed Report will not be in the same Data Set for exporting all of the data together.  

For instance, I wanted to add the "Craft" field to my report data from the "Planned Labor" category.  It turns the report into a Detailed Report and then keeps the Craft field separate when trying to export all my data.  As example, I  had 52 records in my filter....and Exporting Data mad 52 separate Data Sets just for each record for this craft field.  

This would be the same problem for many other report I would want.  For instance Downtime to include Regular Hours from the Actual Labor category would cause the same issue.  

Not sure what I am doing wrong or if it is a limitation...

Nicolas,

I am sorry but I do not see your previous post!?  I greatly appreciate you replying to my post here.  I am still trying to work through the issue and if possible I would like to see what you had previously posted.  

Kind regards

Barry

Hello Barry,  I didn't saw any answer to my previous post.  Is your question still  pending ?

Best regards

------------------------------
Nicolas DESCAMPS
Cognos Expert with Maximo knowledge



Original Message:
Sent: Tue August 08, 2023 06:36 AM
From: Barry Londrigan
Subject: Exporting Data in Ad Hoc Report difficulty

Is it possible that someone might know and could just tell me what I am looking to do - Is it possible or am I barking up the wrong tree?

Also, I am new to Maximo.  I keep seeing posts on Cognos.  Is this something that is an add on that needs to be purchased?  Nobody here at our company has heard of it.  Perhaps this "program" will allow me to do what I am looking to do?

Well, I see in my infinite computer skills while editing I must have deleted a paragraph or two so let me fill in the gap.

The Problem:  I make my filter on the work order screen.   -- Go to Create Report  - Preview Report - and can easily then Export Date into a csv file to manipulate the data.  Easy enough.  But if I go to the Content tab and add any field that turns the report into a "Detailed Report"  and then try to go through the process of Exporting Data, any of the fields that turn the report into a Detailed Report will not be in the same Data Set for exporting all of the data together.  

For instance, I wanted to add the "Craft" field to my report data from the "Planned Labor" category.  It turns the report into a Detailed Report and then keeps the Craft field separate when trying to export all my data.  As example, I  had 52 records in my filter....and Exporting Data mad 52 separate Data Sets just for each record for this craft field.  

This would be the same problem for many other report I would want.  For instance Downtime to include Regular Hours from the Actual Labor category would cause the same issue.  

Not sure what I am doing wrong or if it is a limitation...

Hello Barry,  I didn't saw any answer to my previous post.  Is your question still  pending ?

Best regards

------------------------------
Nicolas DESCAMPS
Cognos Expert with Maximo knowledge

------------------------------


Original Message:
Sent: Tue August 08, 2023 06:36 AM
From: Barry Londrigan
Subject: Exporting Data in Ad Hoc Report difficulty

Is it possible that someone might know and could just tell me what I am looking to do - Is it possible or am I barking up the wrong tree?

Also, I am new to Maximo.  I keep seeing posts on Cognos.  Is this something that is an add on that needs to be purchased?  Nobody here at our company has heard of it.  Perhaps this "program" will allow me to do what I am looking to do?

Well, I see in my infinite computer skills while editing I must have deleted a paragraph or two so let me fill in the gap.

The Problem:  I make my filter on the work order screen.   -- Go to Create Report  - Preview Report - and can easily then Export Date into a csv file to manipulate the data.  Easy enough.  But if I go to the Content tab and add any field that turns the report into a "Detailed Report"  and then try to go through the process of Exporting Data, any of the fields that turn the report into a Detailed Report will not be in the same Data Set for exporting all of the data together.  

For instance, I wanted to add the "Craft" field to my report data from the "Planned Labor" category.  It turns the report into a Detailed Report and then keeps the Craft field separate when trying to export all my data.  As example, I  had 52 records in my filter....and Exporting Data mad 52 separate Data Sets just for each record for this craft field.  

This would be the same problem for many other report I would want.  For instance Downtime to include Regular Hours from the Actual Labor category would cause the same issue.  

Not sure what I am doing wrong or if it is a limitation...

Is it possible that someone might know and could just tell me what I am looking to do - Is it possible or am I barking up the wrong tree?

Also, I am new to Maximo.  I keep seeing posts on Cognos.  Is this something that is an add on that needs to be purchased?  Nobody here at our company has heard of it.  Perhaps this "program" will allow me to do what I am looking to do?

Well, I see in my infinite computer skills while editing I must have deleted a paragraph or two so let me fill in the gap.

The Problem:  I make my filter on the work order screen.   -- Go to Create Report  - Preview Report - and can easily then Export Date into a csv file to manipulate the data.  Easy enough.  But if I go to the Content tab and add any field that turns the report into a "Detailed Report"  and then try to go through the process of Exporting Data, any of the fields that turn the report into a Detailed Report will not be in the same Data Set for exporting all of the data together.  

For instance, I wanted to add the "Craft" field to my report data from the "Planned Labor" category.  It turns the report into a Detailed Report and then keeps the Craft field separate when trying to export all my data.  As example, I  had 52 records in my filter....and Exporting Data mad 52 separate Data Sets just for each record for this craft field.  

This would be the same problem for many other report I would want.  For instance Downtime to include Regular Hours from the Actual Labor category would cause the same issue.  

Not sure what I am doing wrong or if it is a limitation...

Barry - 

Hi.  I'm sorry for the delay in response.   Below please find responses to your questions - if I've missed any - please let me know.

1. On exporting the data - you are correct in using the 'Export Report' button as you noted above.
2. When you note that if you add any field (ex. Craft from Planned Labor) - it turns the report into a Detail report -- there are a few more items to consider.   
   1.  Planned Labor is a child object of Workorder with Multiple Cardinality (1:N) meaning that multiple planned labor records can exist for a single record.  So in this case - Maximo forces the report to be a Detail report.   And exporting a Detail report to xls/pdf - each individual record (WO #) is shown on a unique page or worksheet.
   2. If you add a field from a child object where the cardinality is single (1:1) like Asset or Job Plan, the report would stay as a list report.  And list reports export to a single sheet in xls.
3. If you are interested in more details on QBR (Ad Hoc) Reporting, here are 2 docs that may be helpful to you
   1. QBR Reporting Worksheet (Contains Business Rules including the Style questions you are having) at https://www.ibm.com/support/pages/maximo-7608-qbr-ad-hoc-reporting-worksheet
   2. QBR Reporting Guide:  Document detailing the functionality                                                                               https://www.ibm.com/support/pages/maximo-76-qbr-ad-hoc-reporting-and-ros-guide
4. Additionally, you asked about Cognos.  Depending on the specific Maximo version you are using, along with how your Maximo environment is deployed, there may be entitlement for Cognos Analytics without the need to purchase Cognos licenses.   For example, if you are on Maximo 7.6.1.2 or higher, and have an on-prem deployment, there is entitlement to Cognos 11.0.13 as noted here.   It is difficult to say if Cognos will solve your problem or not.   Other options that may be simpler to test include Application Exporting (Export large volumes of data to csv)
   1. This video details how you can export large volumes of Maximo data  (Note:  This video uses the Maximo data export for Cognos - but you could simply use the data export for analysis in xls)

Thank you.

Pam Denny

pdenny@mavenasset.com

Is it possible that someone might know and could just tell me what I am looking to do - Is it possible or am I barking up the wrong tree?

Also, I am new to Maximo.  I keep seeing posts on Cognos.  Is this something that is an add on that needs to be purchased?  Nobody here at our company has heard of it.  Perhaps this "program" will allow me to do what I am looking to do?

Barry - 

Hi.  I'm sorry for the delay in response.   Below please find responses to your questions - if I've missed any - please let me know.

1. On exporting the data - you are correct in using the 'Export Report' button as you noted above.
2. When you note that if you add any field (ex. Craft from Planned Labor) - it turns the report into a Detail report -- there are a few more items to consider.   
   1.  Planned Labor is a child object of Workorder with Multiple Cardinality (1:N) meaning that multiple planned labor records can exist for a single record.  So in this case - Maximo forces the report to be a Detail report.   And exporting a Detail report to xls/pdf - each individual record (WO #) is shown on a unique page or worksheet.
   2. If you add a field from a child object where the cardinality is single (1:1) like Asset or Job Plan, the report would stay as a list report.  And list reports export to a single sheet in xls.
3. If you are interested in more details on QBR (Ad Hoc) Reporting, here are 2 docs that may be helpful to you
   1. QBR Reporting Worksheet (Contains Business Rules including the Style questions you are having) at https://www.ibm.com/support/pages/maximo-7608-qbr-ad-hoc-reporting-worksheet
   2. QBR Reporting Guide:  Document detailing the functionality                                                                               https://www.ibm.com/support/pages/maximo-76-qbr-ad-hoc-reporting-and-ros-guide
4. Additionally, you asked about Cognos.  Depending on the specific Maximo version you are using, along with how your Maximo environment is deployed, there may be entitlement for Cognos Analytics without the need to purchase Cognos licenses.   For example, if you are on Maximo 7.6.1.2 or higher, and have an on-prem deployment, there is entitlement to Cognos 11.0.13 as noted here.   It is difficult to say if Cognos will solve your problem or not.   Other options that may be simpler to test include Application Exporting (Export large volumes of data to csv)
   1. This video details how you can export large volumes of Maximo data  (Note:  This video uses the Maximo data export for Cognos - but you could simply use the data export for analysis in xls)

Thank you.

Pam Denny

pdenny@mavenasset.com

Is it possible that someone might know and could just tell me what I am looking to do - Is it possible or am I barking up the wrong tree?

Also, I am new to Maximo.  I keep seeing posts on Cognos.  Is this something that is an add on that needs to be purchased?  Nobody here at our company has heard of it.  Perhaps this "program" will allow me to do what I am looking to do?

Well, I see in my infinite computer skills while editing I must have deleted a paragraph or two so let me fill in the gap.

The Problem:  I make my filter on the work order screen.   -- Go to Create Report  - Preview Report - and can easily then Export Date into a csv file to manipulate the data.  Easy enough.  But if I go to the Content tab and add any field that turns the report into a "Detailed Report"  and then try to go through the process of Exporting Data, any of the fields that turn the report into a Detailed Report will not be in the same Data Set for exporting all of the data together.  

For instance, I wanted to add the "Craft" field to my report data from the "Planned Labor" category.  It turns the report into a Detailed Report and then keeps the Craft field separate when trying to export all my data.  As example, I  had 52 records in my filter....and Exporting Data mad 52 separate Data Sets just for each record for this craft field.  

This would be the same problem for many other report I would want.  For instance Downtime to include Regular Hours from the Actual Labor category would cause the same issue.  

Not sure what I am doing wrong or if it is a limitation...

Barry - 

Hi.  With your Maximo Version (Maximo 7.6.1.1 - you are still entitled to Cognos - just a different version.   Maximo 7.6.1.1 entitles you to Cognos 11.0.11.  

To find information on this entitlement - go to the 'Library' Tab of this community - and under the 'Main Folder' there is a file called 'Maximo Report Reference Documents and Video Recordings'.  Download that file - and it will give you 2 worksheets with Cognos demos and documentation.

Please note however, that installing and configuring Cognos to work with Maximo can be a complex and time-consuming task.

If you are simply looking to export data from Maximo - I would encourage you first to try Application Exporting (App Export).  With App Export - there are no installs, integrations or configurations requried.

Please email me direct if you have any more questions.

Thank you -

Pam Denny

pdenny@mavenasset.com

Barry - 

Hi.  I'm sorry for the delay in response.   Below please find responses to your questions - if I've missed any - please let me know.

1. On exporting the data - you are correct in using the 'Export Report' button as you noted above.
2. When you note that if you add any field (ex. Craft from Planned Labor) - it turns the report into a Detail report -- there are a few more items to consider.   
   1.  Planned Labor is a child object of Workorder with Multiple Cardinality (1:N) meaning that multiple planned labor records can exist for a single record.  So in this case - Maximo forces the report to be a Detail report.   And exporting a Detail report to xls/pdf - each individual record (WO #) is shown on a unique page or worksheet.
   2. If you add a field from a child object where the cardinality is single (1:1) like Asset or Job Plan, the report would stay as a list report.  And list reports export to a single sheet in xls.
3. If you are interested in more details on QBR (Ad Hoc) Reporting, here are 2 docs that may be helpful to you
   1. QBR Reporting Worksheet (Contains Business Rules including the Style questions you are having) at https://www.ibm.com/support/pages/maximo-7608-qbr-ad-hoc-reporting-worksheet
   2. QBR Reporting Guide:  Document detailing the functionality                                                                               https://www.ibm.com/support/pages/maximo-76-qbr-ad-hoc-reporting-and-ros-guide
4. Additionally, you asked about Cognos.  Depending on the specific Maximo version you are using, along with how your Maximo environment is deployed, there may be entitlement for Cognos Analytics without the need to purchase Cognos licenses.   For example, if you are on Maximo 7.6.1.2 or higher, and have an on-prem deployment, there is entitlement to Cognos 11.0.13 as noted here.   It is difficult to say if Cognos will solve your problem or not.   Other options that may be simpler to test include Application Exporting (Export large volumes of data to csv)
   1. This video details how you can export large volumes of Maximo data  (Note:  This video uses the Maximo data export for Cognos - but you could simply use the data export for analysis in xls)

Thank you.

Pam Denny

pdenny@mavenasset.com

Is it possible that someone might know and could just tell me what I am looking to do - Is it possible or am I barking up the wrong tree?

Also, I am new to Maximo.  I keep seeing posts on Cognos.  Is this something that is an add on that needs to be purchased?  Nobody here at our company has heard of it.  Perhaps this "program" will allow me to do what I am looking to do?