running on windows

No Joel

Thank yo Joel, when i used the runcat command, it is failing with the below error The script looks like this: runcat.cmd/runcat.sh -cmd report -online http://localhost:9704/analytics/saw.dll –credentials C:\creds.txt C:\Temp\Analysis_Output.txt -type "Analysis" -fields "Column" "Table" The error that I am getting is:…

so thats the reason we are looking at webservices.

Thank You Joel, but we are looking to automate instead of manual selection, since the above selection is manual. Can you suggest any.

Thank you Joel for the update. I am able to establish a webservice call to OBIEE from my SOPA UI. I am unable find the method name which will let me know the subject area, presentation table name and presentation column name of a report which name i passed as a parameter. Can you please suggest. Regards, Moses

Thanks Thomas.. I just compared the data W_HR_PERSON_D and W_EMPLOYEE_D and see the same what you mentioned.. W_EMPLOYEE_D is having idle values of W_HR_PERSON_D. I am analyzing the ODI interfaces how they picking these values identical. Thank you.

Thanks Thomas, Sorry.. I want to know where these external candidate information stores in OBIA Datawarehouse Schema. I am looking for table name where these details will be stored. Lot of people referring to W_EMPLOYEE_D, But i am not satisfied since external candidate don't have EMPLOYEE NUMBER then how can i place a…