BIP (BIPUBLISHER) Using PS_Query

HOW TO CREATE BI-PUBLISHER REPORT
CREATE PS QUERY BASED ON REQUIRMENTS OF OUR REPORT
REGISTER BIP DATA SOURCE
STEP:1MAINMENU>REPORTING TOOLS>
BI PUBLISHER>
REGISTER BIP DATA SOURCE		ADD NEW VALUE (+) SOURCE TYPE=QUERY
SOURCE ID= PS-QUERY NAME
GENERATE XML FOR OUR QUERY
DOWNLOAD THAT XML FILE
UPLOAD THAT FILE IN WORD BI PUBLISHER
MODIFY THE WORF FILE BASED ON OUR REQUIRMENTS
SAVE THAT FILE AS RTCH TEXT FORMATE(RTF)
CREATING BIP REPORT DEFINITION
STEP:2MAINMENU>REPORTING TOOLS>
BI PUBLISHER>
CREATE BIP REPORT DEFINITION		ADD NEW VALUE (+) REPORT NAME= NEW NAME FOR REPORT
DATA SOURCR TYPE=QUERY
DATA SOURCT ID=PS-QUERY NAME
INSIDE TABS1.DEFINITION TAB
DESCR=CREATE DESCR
REPORT STATUS ACTIVE
MAKE IT ALLUSERS		2.TEMPLATE TAB
CHANGE STATUS TO ACTIVE
UPLODE RTF FILE		3.OUTPUT TAB
CHANGE OUT PUT TYPE AS PER YOUR REQUIRMENTS
MAKE DEFAULT AS PDF
BIP QUERY REPORT VIEWER
STEP:3MAINMENU>REPORTING TOOLS>
BI PUBLISHER>
BIP QUERY REPORT VIEWER		REPORT NAME=(WHAT WE CREATE
IN STEP 2)
AND VIEW REPORT
BIP QUERY REPORT VIEWER -WITH BURSTING
IF WE BURST OUR REPORT BASED ON ANY FEILD WE CAN'T ABLE TO SEE IN REPORT VIEWER
WE CAN USE BELOW STEP TO SEE THAT REPORT
STEP:4MAINMENU>REPORTING TOOLS>
BI PUBLISHER>
BIP QUERY REPORT SHEDULER		ADD NEW VALUE (+) 1.RUNCONTROL ID
2.GIVE REPORT NAME AND SERCH
3.Template As Of Date =REPORT CREATED DATE
AND RUN
4.IN PROCESS MONITOR WAIT FOR SUCCESS AND POSTED
5.REPORT MANAGER>ADMINISTRATOR (SEE YOUR REPORTS AS PDF)

 

Comments

Post a Comment

Popular posts from this blog

SQL TO SEE ALL THE OBJECTS IN PROJECT BY PROJECT NAME (PEOPLESOFT)

SELECT PROJECTNAME  ,OBJECTTYPE     , CASE OBJECTTYPE WHEN 0 THEN CASE NVL((     SELECT RECTYPE      FROM PSRECDEFN     WHERE RECNAME = I.OBJECTVALUE1), 99) WHEN 0 THEN 'SQL Table in DB' WHEN 1 THEN 'SQL View in DB' WHEN 2 THEN  'Work Record' WHEN 3 THEN 'Sub Record' WHEN 5 THEN 'Dynamic View' WHEN 6 THEN 'Query View' WHEN 7 THEN  'Temporary Table' ELSE 'Other Record or Deleted' END WHEN 1 THEN 'Index' WHEN 2 THEN 'Field' WHEN 3 THEN  'Field Format' WHEN 4 THEN 'Translate Value' WHEN 5 THEN 'Page' WHEN 6 THEN 'Menu' WHEN 7 THEN 'Component'  WHEN 8 THEN 'Record PeopleCode' WHEN 9 THEN 'Menu PeopleCode' WHEN 10 THEN 'Query' WHEN 11 THEN 'Tree  Structure' WHEN 12 THEN 'Tree' WHEN 13 THEN 'Access Group' WHEN 14 THEN 'Color' WHEN 15 THEN 'Style' WHEN 16  THEN 'Business Process Map' WHEN 17 THEN 'Bu...
Read more

BASIC GLOBAL SEARCH IN PEOPLESOFT

  HOW TO CREATE GLOBAL SEARCH MAINMENU>REPORTINGTOOLS>QUERY MANAGER STEP:1 MAINMENU>REPORTING TOOLS > QUERY MANAGER> 1.LAST EFFDATE COLUMN 2.CRETRIA FOR EFFDT  IS NOT LESS THAN CREATE A PSQUERY   OR (USE CONNECTED QUERY)  OR (USE DOCUMENTS ALSO) PEOPLETOOLS>SEARCH FRAME WORK>DESIGNER> DEFINE SEARCH DEFINITION STEP:1 PEOPLETOOLS>SEARCHFRAMEWORK> DESIGNER>  DEFINE SEARCH DEFNITIONS 1.MAP DATE ,LINK COLUMN 2.ADD TITLE,SUMMARY 3.MAP SEARCH ATTRIBUTE IN TOP (SELECT FIELDS FOR GLOBAL SEARCH DISPAY)&FACETED ADD NEW VALUE CREATE SEARCH DEFINITION NAME*   SOURCE TYPPE =QUERY ADD+ SOURCE NAME=PS_QUERY NAME DEFINE SEARCH CATAGORY STEP:2 PEOPLETOOLS>SEARCH FRAMEWORK>  DESIGNER>   DEFINE SEARCH CATEGORIES CHECK BOX (SEARCH GROUP) MAP SEARCH  DEFINITION NAME BELOW AND SAVE ADD NEW VALUE SEARCH CATEGUARY=SAME NAME SEARCH DEFNITION NAME PEOPLETOOLS>SEARCH FRAME WORK>ADMINISTRATOR> DEFINE SEARCH CONT...
Read more