data entry @prompt

building semantic layer
1

Hi all,
we have a table with four columns as below:

Company Employee #Months Salary
IBM------------A--------------1-----------20
IBM------------B--------------1----------- 30
AMEX----------A--------------1----------- 20
AMEX----------B- -------------1----------- 40
IBM------------C--------------1----------- 50
GOOLGE------ A--------------1----------- 10
IBM------------D--------------1----------- 30
GOOGLE-------B--------------1-----------40

the required output should look like:

Company Employee #Months Salary
IBM------------A--------------1.5---------30
IBM------------B--------------2-----------60
IBM------------C--------------3.8---------190
IBM------------D--------------.5----------15

in order to get the result …first prompt is on the company - which works fine.

the second prompt should be on employee where the user can punch in his own number for months like 3.08 and this entry should be taken to each employee individually for a specific company.

–i know business objects is not for data entry but is there any work around to achieve this output…

Version: BI 4.0 SP 05
DB: Oracle 11g.

any ideas on this appreciated
Thanks,
Bandreddy

Bandreddy :us: (BOB member since 2011-05-04)

2

No, as you rightly said BO is not used for data entry.
You should look at creating a simple screen where employees can enter this data. Then you can report on it.

Mak 1 :uk: (BOB member since 2005-01-06)

3

Thanks for the reply Mak 1.
can you give me an idea to create the simple screen

-Bandreddy

Bandreddy :us: (BOB member since 2011-05-04)

4

Hi,

you can do
-create Screen using Java or .net.to enter data and for reporting purpose u can use crystal report.

Regards,
Atm

atulm (BOB member since 2012-06-30)

5

Thanks for the reply atm-

can you provide me with the code, if you have any…because i have no idea how to create a screen using java.

-Bandreddy

Bandreddy :us: (BOB member since 2011-05-04)

6

.net from the microsoft site:-
http://msdn.microsoft.com/en-us/library/aa479330.aspx

Mak 1 :uk: (BOB member since 2005-01-06)