PM Forecast Report
Options
<p><span style="font-size:12px;">[font="arial, helvetica, sans-serif;"]Dear All, [/font]</span></p><p> </p><p>[font="arial, helvetica, sans-serif;"]<span style="font-size:12px;">I've got a PM forecast report which I would like to display like the following below. But instead of X, I would like to show the interval i.e X is replaced with M for monthly.[/font]</span></p><p> </p><p><span style="font-size:14px;">I was hoping someone could help with a report I'm trying to create. </span></p><p> </p><p><span style="font-size:14px;"><strong class='bbc'> </strong></span></p><p><span style="font-size:14px;"><strong class='bbc'><span style="font-size:10px;">PM Decscription Location JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC<br />
PMXXXXXX DESCXXXXXXXXXXXXXXXXX(Q) BLD349 X - - X - - X - - X - -</span><br />
<span style="font-size:10px;">PMXXXXXX DESCXXXXXXXXXXXXX(1M, 12M BLD349 X X X X X X X X X X X X</span></strong></span><br />
</p><p> </p><p><span style="font-size:14px;">I've grouped the table by YEAR then PMNUM and have placed the information in the PMNUM group header.</span></p><p><span style="font-size:14px;">I've then created aggregations filtered by date, grouped by PMNUM.</span></p><p><span style="font-size:14px;">If there is a value above 0, on the render, I've scripted it so it shows an X. Vice versa, if the value is 0 then I display an -. The trick I am stuck with is the group header will always display the first record even if I filter the aggregation. I would love to know how to choose the record to show the interval.</span></p><p><span style="font-size:14px;"> </span></p><p><span style="font-size:14px;">If anyone could please point me in the right direction, that would be much appreciated.</span></p><p><span style="font-size:14px;">I can also attach the report if required.</span></p><p><span style="font-size:14px;"> </span></p><p><span style="font-size:14px;">Thank you</span></p><p><span style="font-size:14px;"> </span></p><p><span style="font-size:14px;">Regards, </span></p><p><span style="font-size:14px;"> </span></p><p><span style="font-size:14px;">David</span></p><p><span style="font-size:14px;"> </span></p><p><span style="font-size:10px;"> </span></p><p> </p><p> </p><p> </p>
PMXXXXXX DESCXXXXXXXXXXXXXXXXX(Q) BLD349 X - - X - - X - - X - -</span><br />
<span style="font-size:10px;">PMXXXXXX DESCXXXXXXXXXXXXX(1M, 12M BLD349 X X X X X X X X X X X X</span></strong></span><br />
</p><p> </p><p><span style="font-size:14px;">I've grouped the table by YEAR then PMNUM and have placed the information in the PMNUM group header.</span></p><p><span style="font-size:14px;">I've then created aggregations filtered by date, grouped by PMNUM.</span></p><p><span style="font-size:14px;">If there is a value above 0, on the render, I've scripted it so it shows an X. Vice versa, if the value is 0 then I display an -. The trick I am stuck with is the group header will always display the first record even if I filter the aggregation. I would love to know how to choose the record to show the interval.</span></p><p><span style="font-size:14px;"> </span></p><p><span style="font-size:14px;">If anyone could please point me in the right direction, that would be much appreciated.</span></p><p><span style="font-size:14px;">I can also attach the report if required.</span></p><p><span style="font-size:14px;"> </span></p><p><span style="font-size:14px;">Thank you</span></p><p><span style="font-size:14px;"> </span></p><p><span style="font-size:14px;">Regards, </span></p><p><span style="font-size:14px;"> </span></p><p><span style="font-size:14px;">David</span></p><p><span style="font-size:14px;"> </span></p><p><span style="font-size:10px;"> </span></p><p> </p><p> </p><p> </p>
0
Comments
-
<p><span>Hi All,
I've fixed the issue and have created the report that looks like (follow the link)
<a data-ipb='nomediaparse' href='http://www.linkedin.com/redirect?url=https://drive.google.com/file/d/0B_MIIGlMK-PFZllmVW5LXzdMTTA/edit?usp=sharing&urlhash=nkFk&_t=tracking_disc'>https://drive.google.com/file/d/0B_MIIGlMK-PFZllmVW5LXzdMTTA/edit?usp=sharing</a>
It's Grouped by PM number and then Asset number.
If anyone is interested in the report, please let me know.
Thanks
Regards,
David</span></p>0 -
<blockquote class="ipsBlockquote" data-author="DavidRiep" data-cid="129174" data-time="1404608699">
<div>
<p>Hi All, I've fixed the issue and have created the report that looks like (follow the link) <a data-ipb='nomediaparse' href='http://www.linkedin.com/redirect?url=https://drive.google.com/file/d/0B_MIIGlMK-PFZllmVW5LXzdMTTA/edit?usp=sharing&urlhash=nkFk&_t=tracking_disc'>https://drive.google.com/file/d/0B_MIIGlMK-PFZllmVW5LXzdMTTA/edit?usp=sharing</a> It's Grouped by PM number and then Asset number. If anyone is interested in the report, please let me know. Thanks Regards, David</p>
</div>
</blockquote>
<p>Hi David,</p>
<p> </p>
<p>I'm interested in your report. I'm a relative novice creating BIRT reports but trying to do the same PM forecast at the moment.</p>
<p> </p>
<p>Thanks,</p>
<p>Scott</p>0 -
<p>Hi,</p>
<p> </p>
<p>I realy like this report. If any of you has it, please attach it to this thread or send my an PM.</p>
<p> </p>
<p>Kind,</p>
<p> </p>
<p>regards,</p>
<p> </p>
<p>Jeroen</p>
0 -
<p>Hi David,</p>
<p> </p>
<p>I am interested in this report. If you don't mind please send me a copy.</p>
<p> </p>
<p>Thanks</p>
0 -
<p>Hi David,</p>
<p> </p>
<p>Can you please share the Report design.</p>
<p> </p>
<p>Thanks & Regards</p>
0 -
<p>I have attached a basic PM schedule report. At our Maximo instance we don't use PM's, but I thought I'd try to create something that might lead others to improve. The deeper you get into this the more complicated it becomes. (lots of options)</p>
<p>It is based off the PM.nextdate and this is for Sql Server.</p>
<p> </p>
<p>Wes</p>
0 -
Hi All,
If someone has designed PM forecast report , please share the report design file.0 -
I haven't looked at this or gone any further since 2017 as we don't use the PM module. If you choose to use this as a base please share.
0
Categories
- All Categories
- 109 Developer Announcements
- 49 Articles
- 100 General Questions
- 122 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 123 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management