Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



V7.5 - Ad-Hoc Reporting Functionality

From: shannonrotz (2012-05-23 19:58)

Hi guys:
Anyone know if you can add totals to a report that you're creating through the Ad-Hoc Reporting tool?
I'm trying to create an Inventory report that shows the total balance for each item, but off-hand I can't see a way to do that.
Jason: I bet you know this one ...
Shannon


From: Jason Verly (2012-05-23 21:44)

So if the item is stored in 3 bin locations, and each bin has 2 items, you want the report to show a single row for the itemnum and a cur bal of 6. Is that correct?
--- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@...> wrote:
>
> Hi guys:
>
> Anyone know if you can add totals to a report that you're creating through the Ad-Hoc Reporting tool?
>
> I'm trying to create an Inventory report that shows the total balance for each item, but off-hand I can't see a way to do that.
>
> Jason: I bet you know this one ...
>
>
>
>
> Shannon
>


From: shannonrotz (2012-05-23 22:16)

Yep!
Shannon
--- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
> So if the item is stored in 3 bin locations, and each bin has 2 items, you want the report to show a single row for the itemnum and a cur bal of 6. Is that correct?
>
> --- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@> wrote:
> >
> > Hi guys:
> >
> > Anyone know if you can add totals to a report that you're creating through the Ad-Hoc Reporting tool?
> >
> > I'm trying to create an Inventory report that shows the total balance for each item, but off-hand I can't see a way to do that.
> >
> > Jason: I bet you know this one ...
> >
> >
> >
> >
> > Shannon
> >
>


From: wwilliams (2012-05-23 15:24)

I am thinking you might have to do something with a view, although I haven't tried it.
You can't just make it a report from the QBR?
 
Wes
________________________________
From: shannonrotz <shannonrotz@yahoo.ca>
To: MAXIMO@yahoogroups.com
Sent: Wednesday, May 23, 2012 5:16 PM
Subject: [MAXIMO List] Re: V7.5 - Ad-Hoc Reporting Functionality

 
Yep!
Shannon
--- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
> So if the item is stored in 3 bin locations, and each bin has 2 items, you want the report to show a single row for the itemnum and a cur bal of 6. Is that correct?
>
> --- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@> wrote:
> >
> > Hi guys:
> >
> > Anyone know if you can add totals to a report that you're creating through the Ad-Hoc Reporting tool?
> >
> > I'm trying to create an Inventory report that shows the total balance for each item, but off-hand I can't see a way to do that.
> >
> > Jason: I bet you know this one ...
> >
> >
> >
> >
> > Shannon
> >
>


From: Jason Verly (2012-05-24 14:57)

Wes is right, because the total curbal is a calculated/non-persistent data value you can't do it out of the box with a QBR report. The two choices left are:
1. Try to create a view like Wes suggested and then add that view as part of the report object structure. This a route I'm working on to mimic labor/person availability in Assignment manager.
2. Create the core report via QBR tool and then tweak it in BIRT designer.
--- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@...> wrote:
>
> Yep!
>
>
> Shannon
>
> --- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@> wrote:
> >
> > So if the item is stored in 3 bin locations, and each bin has 2 items, you want the report to show a single row for the itemnum and a cur bal of 6. Is that correct?
> >
> > --- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@> wrote:
> > >
> > > Hi guys:
> > >
> > > Anyone know if you can add totals to a report that you're creating through the Ad-Hoc Reporting tool?
> > >
> > > I'm trying to create an Inventory report that shows the total balance for each item, but off-hand I can't see a way to do that.
> > >
> > > Jason: I bet you know this one ...
> > >
> > >
> > >
> > >
> > > Shannon
> > >
> >
>


From: shannonrotz (2012-05-24 15:06)

Right - thanks Jason. I thought it might be something like that!
Shannon
--- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
> Wes is right, because the total curbal is a calculated/non-persistent data value you can't do it out of the box with a QBR report. The two choices left are:
>
> 1. Try to create a view like Wes suggested and then add that view as part of the report object structure. This a route I'm working on to mimic labor/person availability in Assignment manager.
>
> 2. Create the core report via QBR tool and then tweak it in BIRT designer.
>
>
>
> --- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@> wrote:
> >
> > Yep!
> >
> >
> > Shannon
> >
> > --- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@> wrote:
> > >
> > > So if the item is stored in 3 bin locations, and each bin has 2 items, you want the report to show a single row for the itemnum and a cur bal of 6. Is that correct?
> > >
> > > --- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@> wrote:
> > > >
> > > > Hi guys:
> > > >
> > > > Anyone know if you can add totals to a report that you're creating through the Ad-Hoc Reporting tool?
> > > >
> > > > I'm trying to create an Inventory report that shows the total balance for each item, but off-hand I can't see a way to do that.
> > > >
> > > > Jason: I bet you know this one ...
> > > >
> > > >
> > > >
> > > >
> > > > Shannon
> > > >
> > >
> >
>


From: Gideon Olivar (2012-05-24 14:59)

Hi Shannon,
You are using 7.5 right? You can create an object structure with Inventory tables with the relationships. You can select persistent and non-persistent columns with it. Then define that the object structure you have created will be used by reporting. Once you have this setup, then you can use QBR for it. I am happy to provide you the details if what I am saying makes sense to you.
Regards
________________________________
From: shannonrotz <shannonrotz@yahoo.ca>
To: MAXIMO@yahoogroups.com
Sent: Friday, 25 May 2012 1:06 AM
Subject: [MAXIMO List] Re: V7.5 - Ad-Hoc Reporting Functionality

 
Right - thanks Jason. I thought it might be something like that!
Shannon
--- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
> Wes is right, because the total curbal is a calculated/non-persistent data value you can't do it out of the box with a QBR report. The two choices left are:
>
> 1. Try to create a view like Wes suggested and then add that view as part of the report object structure. This a route I'm working on to mimic labor/person availability in Assignment manager.
>
> 2. Create the core report via QBR tool and then tweak it in BIRT designer.
>
>
>
> --- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@> wrote:
> >
> > Yep!
> >
> >
> > Shannon
> >
> > --- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@> wrote:
> > >
> > > So if the item is stored in 3 bin locations, and each bin has 2 items, you want the report to show a single row for the itemnum and a cur bal of 6. Is that correct?
> > >
> > > --- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@> wrote:
> > > >
> > > > Hi guys:
> > > >
> > > > Anyone know if you can add totals to a report that you're creating through the Ad-Hoc Reporting tool?
> > > >
> > > > I'm trying to create an Inventory report that shows the total balance for each item, but off-hand I can't see a way to do that.
> > > >
> > > > Jason: I bet you know this one ...
> > > >
> > > >
> > > >
> > > >
> > > > Shannon
> > > >
> > >
> >
>


From: mohska (2012-05-24 23:33)

I dont think you can use non persistent fields for QBR
Everything Will Work fine until you use the OBject structure in the QBR (from What i remember in 7.1)
Sent from my iPhone
On 24 May 2012, at 22:59, Gideon Olivar <g_olivar2002@yahoo.com> wrote:
> Hi Shannon,
>
> You are using 7.5 right? You can create an object structure with Inventory tables with the relationships. You can select persistent and non-persistent columns with it. Then define that the object structure you have created will be used by reporting. Once you have this setup, then you can use QBR for it. I am happy to provide you the details if what I am saying makes sense to you.
>
> Regards
>
> ________________________________
> From: shannonrotz <shannonrotz@yahoo.ca>
> To: MAXIMO@yahoogroups.com
> Sent: Friday, 25 May 2012 1:06 AM
> Subject: [MAXIMO List] Re: V7.5 - Ad-Hoc Reporting Functionality
>
>
>
> Right - thanks Jason. I thought it might be something like that!
>
> Shannon
>
> --- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
> >
> > Wes is right, because the total curbal is a calculated/non-persistent data value you can't do it out of the box with a QBR report. The two choices left are:
> >
> > 1. Try to create a view like Wes suggested and then add that view as part of the report object structure. This a route I'm working on to mimic labor/person availability in Assignment manager.
> >
> > 2. Create the core report via QBR tool and then tweak it in BIRT designer.
> >
> >
> >
> > --- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@> wrote:
> > >
> > > Yep!
> > >
> > >
> > > Shannon
> > >
> > > --- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@> wrote:
> > > >
> > > > So if the item is stored in 3 bin locations, and each bin has 2 items, you want the report to show a single row for the itemnum and a cur bal of 6. Is that correct?
> > > >
> > > > --- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@> wrote:
> > > > >
> > > > > Hi guys:
> > > > >
> > > > > Anyone know if you can add totals to a report that you're creating through the Ad-Hoc Reporting tool?
> > > > >
> > > > > I'm trying to create an Inventory report that shows the total balance for each item, but off-hand I can't see a way to do that.
> > > > >
> > > > > Jason: I bet you know this one ...
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Shannon
> > > > >
> > > >
> > >
> >
>
>
>
>


From: Bart Wiltink (2012-05-26 12:08)

Hi Shannon,
I don't think this is possible using the ad-hoc reporting tool (QBR), but
guys correct me if I'm wrong!
What I do know is that it's possible to add totals and various other
calculations using Cognos (Tivoli Common Reporting integration).
A slender version of Cognos comes free of license costs with Maximo 7.5.
See attached install document.
bart.wiltink@gmail.com
2012/5/23 shannonrotz <shannonrotz@yahoo.ca>
> **
>
>
> Hi guys:
>
> Anyone know if you can add totals to a report that you're creating through
> the Ad-Hoc Reporting tool?
>
> I'm trying to create an Inventory report that shows the total balance for
> each item, but off-hand I can't see a way to do that.
>
> Jason: I bet you know this one ...
>
> Shannon
>
>
>
--
Met vriendelijke groeten,
Bart Wiltink