REPORTING INTERVIEW QUESTIONS
1.what is data source?
A.it is nothing but a view one primary business object and number of related
business objects.
2.what is business object?
A.it is nothing but a table like SQL
3.types of custom reports?
A.1.simple report
2.advanced report
3.matrix report
4.composite report
5.N box report
6.search box report
7.trending report
8.transposed report
4.what is difference between simple and advanced reports?
A. simple report advanced report
1.simple report we cont pass 1. advanced report we can call
the integration level. the integration leval.
2.share tab is not available 2.share tab is available in
in simple report. advanced report.
3.only 3 tabs are available 3.7 tabs are available in
in simple report. advanced report.
5.what is difference between filter and subfilter?
A. primary business object we can use in filetr level
related business object we can use in subfilter level.
6.what is difference between ESI and EMI?
Ex: Employee get salary changes in 5 times by using extract single instance
we can get any single row of data eighter first occurance (or) middle occurance
(or) last occurance
by using extract multi instance we can get all rows at atime.
7.what is difference between calculated fields and custom fields?
A. calculated fields we have doing validations,data formatting,different type
of functions write in calculatios.
custom fields means some additional fields we can maintain.
8.what is difference between matrix and composite report?
A. matrix report composite report
1.data source use in matrix 1.business object use in composite
report.
report.
2.at time one data source use in 2. multibule data sources call in
composite report.
matrix report.
3.non configurable calculation:can use 3.configurable
calculation:sum,difference,multiply,divide,
do totals counts,avarages etc. in comosite report.
9.complex task in reporting?
A.i have a requirment for matrix report
my business want to see the all head count of each country & cost center wise
for that purpose i have created one new custom report.
STEPS:
1.firstly given report name,report type matrix,data source all active and
terminated workers.
2.basically in matrix report most important tabs matrix & drill down
3.in matrix tab has 3 main elements row grouping,column grouping,summirze
4.i have selected location address and country in row grouping
5.comming to drill down tab here my business wants to see the view details of
each country and cost center,
region,company,employee
6.i have selected required fields in detailed element.
7.based on that my business seen the all country details.
INTEGRATION INTERVIEW
QUESTIONS
10.complex integration in eib?
A. resentely i have created eib integration for request one time payment,
so the challenge here actually all the bouns and compensation we are loading
request one time payment here one time payment we are maintain all employee
details information and some additional worktags like project,region,product
these three information is added into additional worktags , if generate
that eib these those additional custom worktags are not apperaining into
your eib template getting issuses like that required worktag information
is missing,so i could obser that and i reading something in community
and can able to understand how i can this is like additional tags so
i just go to view template mode in eib and then simply go to default
worktag section and go manuvally added the project,region,product and regenate
the template make sure that template has been update correct data after that i
map
all data rerun the process it went to sucess.
11.what is difference between eib and core connector?
A. EIB CORE CONNECTOR
1.one web service we can use in eib. 1.multiple web services we can
use in core connector.
2.it generate the single file. 2.it generates the 6 files
3.no services options available in eib 3.comming to core connector 24
services are available.
4.in eib some limitations are their 4.their is no limitations in core
connector.
eib inbound it supports 30 mb file
eib out bound it supports 300 mb
file only.
12.what is sequence generator?
A.sequence generator enables in our integration to generate unique sequenced file
name
each time its runs.
13.what is transection log?
A.by using transection log we can reduce the integration run time.
and also it is pick the specific transection changes.
ex: persanal,compensation.
STUDIO INTERVIEW QUESTIONS
14.difficult task in studio?
A.we have a clarizan system this is like thired party system,the clarizan is
maintain all the opportunities and sales
information all the new deals going to our sales lead actually do some
opportunities that opportunities they are converting
project, we are loading into clarizan system to workday project in that case
actually we are using employee expencies module,
and reambersement module we are using for that, we need a project manager
approval also
ex:we are creating any expencies report we need to select project,if you choose
the project,it will go to project manager approval
also,as of known eib assign roles it is a web service,every week and every
month,we are manuvally download all the project which
are missing project manager role and then we are going to check with the
project related manager information from hr team and
then we are manuvally assign that,so we are thinking why can't be go with
automation kind of writting studio process,
i have implemented for that i have take that project.
Steps: i have created one custom report which are all missing project managers,
just pull all project details,then enable as web service
call it as a rash report after that i am creating my studio process.
workday in local, workday out rest it is calling my web service the rash
report name and alias name after that i am taking another evulate
expression the component is the store what are data from out put file just
storing into one variable that is evulate expression to convert
into xml,after that i have takeing that "xml to xslt"so i just converting
to in your "xml to xslt" and then storing into another evulate
expression which of using spilter we are just storing the value because we
are receiving 25 rows all 25 projects we are using spilters to pick
the data into row by row just i am calling workday soap meaasge so just i
take write component ,to workdat tester with my soap message assign roles
web services and just calling workday soap rest,and then mean wise i m
creating another component send error component which we are exicuting
my responce is their any errors capturing that we are using error
component capturing those errors then writting into another put integration
message and capturing into log details and as well as it is calling into
the my workday soap out rest and then data is sucessfully loaded
i am just taking put integration component to writting into my sucessful
log details how many rows sucessfully loaded into the log file
so then i just detail level of log message i can able to give the end user
to saying the how many rows we are prossed, how many rows we get
failed due to the errors and all we will given detail level of data.
loaded ,how many rows
15.What time we r going to use studio integration?
A.when we are sending data from WD to some third party system or payroll or loading
data to WD that contain more than 2GB , we go for studio integration.
16.How we will add launch parameters in studio?
A. in studio by using StartHere Delivered workday-in component, We have launch
parameters option there we add.
17.How we will call document retrieval service in studio?
A.By using workday-in deliverd component of studio , under services option . By
using create document retrieval services option
18.what is the purpose of spliter?
A.spliter for example we are processing ,we are getting 100 rows of data in the
file,so before calling into the request soap message,
we can't directly pass the 100 rows at a time in request message ,so we need to
row by row process, so actually i am receiving
csv file after that i have use to "xml"component that data is converting into
"csv to xml" the data is communing root/row concept
what information we getting that we are using xml spliter "x path" is mention by
root/row ,couple things we are getting data from
rash report it self and it get report data /report entry. i mention in my "x-
path".
19.what is the use of aggregator?
A.generally we use to putintegration message we capturing all the sucess and error
log information separeatly and then i use to aggregator
function to aggregator two logs into one log comming to the details information
in single file,because the called as total sucess log and
error log information aggregate into single file.
20.how delivered file into sftp server to workday studio?
A.by using document retrival services,so and also delivered component sftp also
their and we want to go email their are deliverd component
so we can use for that they need to configur the integration the document deliver
cofiguration and set up all the relted sftp information
with using authetication url and user name and password.
21.functionality of router?
A.router we are using for example we are using spliter spliting the rows at time,in
that case actually we are using the router, because we are
getting any errors in spliter level, that aggregation level we don't have option
to reacord the all the error before calling the asycrons mediation
mega storing component we can use this router component we can capture those
exceptions to writting into the put integration message ,logs that
purpose we are using routers.
22.what is the use of local in?
A.workday in this is primary,we can able to start the integration, common and
advanced and we need to define the integration name and also we can select
the document retrival services ,document delivery services custom pbject
services,the rash report services we are all use in local in.
23.what is assembly?
A.that is actually project,if you click that assemply we need to design outline
farmat because if you go to the design,source mode
if click that assembly that will be storing all the cloud collection on assembly
mode ,what program start in local in and what
are the coponents which are all used in the assembly we can see the all action
their.
24.what the use of mediation contact?
A.meadiation contact i could obser that we have a collection of component like
write component,store component,xslt,csv to xml and evel expression
these are merging into one meadition.
24.what is the difference between asyncration and sycration mediation?
A.i could obser that asyncration mediation one way direction comming to sycration
mediation both direction :in and out".
25.what is eval expression?
A.in eval expression component we are storing data comming into the each row into
variable.
ex:props[employee_id]=parts[0].xpath('row/employee_id)
this is what i am using eval expression.
26.what is log file?
A.log files is used for checking values by wtitting variables into jason farmat
ex:@{props['employee_id']}
