Закрыт

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

Квалификация: Oracle, Oracle OBIEE

Показать больше 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

О работодателе:
( 0 отзыв(-а, -ов) ) Abu Dhabi, United Arab Emirates

ID проекта: #22691188

10 фрилансеров(-а) в среднем готовы выполнить эту работу за $166

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 за 1 день
(34 отзывов(-а))
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 Больше

$170 USD за 2 дней(-я)
(6 отзывов(-а))
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 за 1 день
(1 отзыв)
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 Больше

$166 USD за 3 дней(-я)
(1 отзыв)
2.0
$194 USD за 5 дней(-я)
(0 отзывов(-а))
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 за 1 день
(0 отзывов(-а))
0.0
$111 USD за 3 дней(-я)
(0 отзывов(-а))
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 Больше

$150 USD за 10 дней(-я)
(0 отзывов(-а))
0.0
simransahani100

Obiee developer

$194 USD за 5 дней(-я)
(0 отзывов(-а))
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 за 1 день
(0 отзывов(-а))
0.0