Đã Đóng

Creating a view on the existing OBIEE 12c report DATA model SQL query

Having a requirement to create a single view on the existing report SQL query which is currently fetching data from multiple resource table. i.e

SELECT port portfolio,

entityname,

id projcode,

id,

pid,

estimated estimatedcost,

costdof approvedprojcostdof,

plannext1year,

plannext2year,

plannext3year,

planmore3year,

totalapprovedvo,

vono,

REVISED_CONTRACTED_VALUE,

subdate requestsubmissiondate,

resdate resolutionreceiveddate,

resref resolutionreference,

projstatus,

designaward,

keychlng,

mitig,

responsible,

issue,

expecteddate expecteddaterslvissue,

loc loction,

designcons designconsultant,

supercons supervisionconsultant,

MUS_TMT66_PMC pmccons,

maincont maincontractor,

pm,

pmcontact,

nationality,

remrks,

client,

budgstatus,

case when Qualitytol=1 then 80 when Qualitytol=2 then 90 when Qualitytol=3 then 100 else 80 end Qualityvar,

CASE WHEN origgovplaned = 0 THEN 0 ELSE round(govplaned / origgovplaned*100,2) END spi,

st,

oldwbs wbs,

ACTIONPLAN,

CLIENTCOMMENTS,

ADDCOMMENTS,

case when budget=0 then 0 else expthisyear/budget*100 end costvar,

prog(st,origgovplaned,govplaned) progstatus,

dofobjid,revobjid

FROM (SELECT [login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL] + [login to view URL] exptill1year,

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

usp.cona+usp.conb+usp.conc+usp.cond+[login to view URL] REVISED_CONTRACTED_VALUE,

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

nvl([login to view URL],[login to view URL])

designaward,

nvl([login to view URL] ,(SELECT TO_CHAR (plannedstartdate, 'dd-Mon-yy')

FROM p6activity

WHERE projectobjectid = [login to view URL]

AND id = 'CN-1015'))

superaward,

[login to view URL],

nvl([login to view URL],

(SELECT TO_CHAR (plannedstartdate, 'dd-Mon-yy')

FROM p6activity

WHERE projectobjectid = [login to view URL]

AND id = 'CN-1015'))

contractoraward,

[login to view URL],

[login to view URL],

govproj([login to view URL],1048) origgovplaned,

govproj([login to view URL],1049)

govplaned,

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

usp.MUS_TMT66_PMC,

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

usp.REASONS_OF_DEVIATION_2,

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

dofobjid,revobjid

FROM p6ddb pro, unifprod.unifier__ddb usp

WHERE [login to view URL] = [login to view URL] AND [login to view URL] = :mon AND [login to view URL] = :yr) xx

Kĩ năng: Oracle, Oracle OBIEE

Xem nhiều hơn: print report data access pages, magento data model, basic rdbms data model, accounting aging report data sample, academic report writing model, airlines reservation system database data model design projects, crystal report modifications migrating data source sql oracle, aspnet crystal report rpt file sql query, data model diagram, project report data analysis, faculty management system data model, convert oracle report data excel, view output excel rdf report 12i, object oriented data model helps develop software system, view sample aspnet crystal report, marketing report data analysis, export admin data qc sql query, data feed sql query, sqlalchemy data model sql

Về Bên Thuê:
( 0 nhận xét ) Abu Dhabi, United Arab Emirates

ID dự án: #22691188

10 freelancer đang chào giá trung bình $166 cho công việc này

adeeladeel1234

hi i have extensive experience in Oracle sql and Obiee dashboards development i can convert this query to view easily please send me message to discuss your requirements in details

$166 USD trong 1 ngày
(34 Nhận xét)
5.2
huseyinaygun

Dear Sir/Madam, I have Oracle database design and development experience of 10 years. I developed reports or enhanced performance of queries in the reports using Oracle Reports, Oracle BI reports, SQL, stored proced Thêm

$170 USD trong 2 ngày
(6 Nhận xét)
3.3
TEKSCENT

hi have around 10 years of experience in SQL development and working as team [login to view URL] me know if I can help you

$222 USD trong 1 ngày
(1 Nhận xét)
1.9
ramobiee10

Hi , I am a OBIEE expert , I have worked in more than 5000+ OBIEE Reports and with different users and projects , I can help you with this project , also I can give you suggestions on any issue in BI reporting I will Thêm

$166 USD trong 3 ngày
(1 Nhận xét)
2.0
$194 USD trong 5 ngày
(0 Nhận xét)
0.0
sukritdobhal

4 years of experience as a senior PL/SQL,SQL. Oracle developer, I will deliver the .vw within 4 hours. with the least billing amount possible.

$111 USD trong 1 ngày
(0 Nhận xét)
0.0
$111 USD trong 3 ngày
(0 Nhận xét)
0.0
PretjeNL

Dear Sir/Madam, I can assist you with this job. I have got knowledge off the following assets : - Creating complex Oracle SQL views for reports (Crystal Reports) - Creating complex functions or packages in Oracle SQL Thêm

$150 USD trong 10 ngày
(0 Nhận xét)
0.0
simransahani100

Obiee developer

$194 USD trong 5 ngày
(0 Nhận xét)
0.0
consultsravan

create a view, ensure no hard coded values, physical,logical, presentation layer changes, create dimensions and fact using single view

$177 USD trong 1 ngày
(0 Nhận xét)
0.0