Effective dating in peoplesoft
Im pretty desperate now as they are currently reviewing the reporting tool they use here and at the moment BO isnt looking good due to the performance issues. Spotfire._________________Business Objects v5, v6, XI R2 and R3.1. OBIEE 10g - 11g (Oracle Business Intelligence Enterprise Edition), OWB 10g, 11g (Oracle warehouse builder). Anyway Im still at work and I shouldnt be, so have a good weekend and thanks for the advice so far. The benefit tables are effected dated so if I used your logic I would pull the wrong info out. Make sure you set the sort to 'No' in the prm file. Ive still got the usual performance problem, I am of the opionion someone out there must have the solution. I had to hunt around for a minute to find a join with an index hint to paste in for you. Im just hoping when they see the other tools on offer they will realise its not just a BO problem. For example a user might want to know what the employee personal details / benefit details were as at the 1/Jan/2001. If you are using rule based optimization, then ranking the tables will help significantly. The history of hypnosis, then, is like the search for something that was in plain view all along, and we can now see it for what it is – a universal phenomenon that’s an inextricable part of being human.The products for humidification and precise evaporation are based upon a deep understanding of physical chemistry and the application of new technologies. I found this site by chance it was link from a company called Metasource Incorporated. We might pull in ps_location_tbl for a custom lov but we have a data warehouse...a materialized view containing a current employee snapshot... Thats what I keep trying to tell them here that the primary universe should only report on current info thus removing the need for the effective dating joins meaning better performance, but thats not how they want it, they want the world on a stick. I am suprised you are having an issue with reporting against psft hr. You may just want constrain the ps_job table with the correlated sub-query. EFFDT Ive got the sub query on job, but the users want to report on history for everything at any point in time so just selecting the max date for other tables wouldnt work. If anyone has experience of it let me know the pro's and con's._________________Business Objects v5, v6, XI R2 and R3.1. OBIEE 10g - 11g (Oracle Business Intelligence Enterprise Edition), OWB 10g, 11g (Oracle warehouse builder). PS_JOB.rowid=(select /* index_desc (c ps_job) */rowid from ods.ps_job c where c.emplid=ODS. EMPLID and c.effdt Hi, Steve you get about a bit, have seen you name in a number of places even one of the entries on the Bus Obj KB makes references to you. We rarely ever report of the People Soft transactional tables. I dont know how BO feel about this but I would guess there not to happy about it, if people only wanted to use BO for Peoplesoft reporting there would defiantly be a strong argument to go with the Psoft solution. For example to fetch data from PS_NAMES table which must be latest information as of today we know to write a simple SQL like below: If the requirement is like NAMES record may not have all the emplids in JOB table then how to write the query? However, Oracle does not allow outer join on a subquery which will prevent us from writing an outer join effdt subquery.
Effective_Date The 1985 ACM Article “A Taxonomy of Time in Databases” by Snodgrass and Ahn is the only Non-People Soft article that presently comes to my mind when describing approaches of this nature.
Although we now know that his notion of “animal magnetism”, transferred from healer to patient through a mysterious etheric fluid, is hopelessly wrong, it was firmly based on scientific ideas current at the time, in particular Isaac Newton’s theories of gravitation.
Nevertheless, the stubborn fact remained that hypnosis worked, and the 19th Century is characterised by individuals seeking to understand and apply its effects.
Because NAMES table has data for this emplid (so NULL condition becomes false) and the row in NAMES table gets dropped as there is no data in NAMES table as on 1st Jan.
If JOB has an EFFDT on or after 12th July for this emplid then the query would fetch results.