Thursday, February 20, 2014

Primavera filter error

Today an old issue raised it head… When creating a filter on the a specific field caused an error is displayed to the User.

clip_image002

This issue addressed with a Primavera HotFix file that was released from Oracle for P6 SP 3.

Copy the file: PM.EXE hotfix file which you can download from the support site, over the existing PM.EXE file on the client PC. This can usually be located in the “C:\Program Files (x86)\Oracle\Primavera P6\Project Management” folder.

Tuesday, February 11, 2014

List of Items in Business Objects

Today one of the Users asked if it was possible to update the list of items that appear in a query list….

clip_image002

For example, the list above shows all months in 2014 .. they only want to see dates in 2013 and 2014.

You can do this using Information Designer.

1) Open the Universe

2) Select the “Parameters List of Values option”

clip_image004

3) Edit the existing list or create a new one.

clip_image006

4) Edit the Query and change the name

clip_image008

5) Add the additional values you want in the list and click OK.

6) clip_image010

7) Next ensure that the filter/field in the Universe is associated with the correct list

8) Click on “Business Layer” and the field; then click “Advanced”

clip_image012

9) Publish the Universe.