Best Approch to develop webi without well designed universe

[Former Member]

Hi All,

We have some old Acutate reports with free hand SQL

and want to migrate to webi .

All the underlying SQL for each report is ready .We dont have time to design universe .

Please guide me for better appoch

• Design universe with derived table - On top of that Webi
• Override the SQL of underlying Webi report

Please help me with some stuff and documents

Regards

Yogi

[Former Member · Accepted solution]

Not an elegant approach...but you can just create derived table based universe and expose the objects in business layer to be consumed In the reports.. This will be quite quick as well..

[nscheaffer]

Do they need to be WebI reports?  You could use Crystal Reports and put the raw SQL in a command object.

Noel

[Former Member]

Thanks Chandrakanth!

I will prepare some dummy/generic objects that has  data type and object type in the object name in universe

I will create the reports based on the dummy fileds and Override the SQL generated by Webi

So as u suggested I can create hierachy with those dummy fileds  for Drill down in universe?

Regards

Yogi

[Former Member]

It depends. Will you always drill from dummy text object 1 down to dummy text object 2 in each report that you want to create drill downs for? As long as you're disciplined and do it properly (ooooo the irony ) then it should work.

[Former Member]

Rather than using query over ride and use of dummy objects which will create a lot of maintenance issue down the line .. I will suggest to create separate derived table based on the query and then expose all the objects from that table to a separate folder to be used in your reports..

You can create your custom hierarchy on top of these objects and drill will work without any issue..

[Former Member]

Thanks Mishra, Chandra Kanth

Please tell me - Can I able to use drill down feature If I go with Custom SQL ?

Regards

Yogi

[Former Member]

You can apply Drill down  feature if u develop universe with derived tables.

Regards,

Chandrakanth

[Former Member]

Hi,

If you create derive tables with your custom sql,the objects you will create from those derive table needs to be defined in the hierarchy, else it will follow the default hierarchy.

You can use your custom hierarchy built on these objects to drill in the report.

Thanks

Gaurav

[Former Member]

This approach of customizing you requirement with derive table will be just short term fixing.

You should plan for a well developed universe for a long term solution.

[Former Member]

Thanks Gaurav!

[Former Member]

Yes Yogeeshwara reddy,

If u don't  have time to develop the universes , then go for your suggested method....It works fine.....

But its not best practice.

Regards,

Chandrakanth