Delete, insert, update using report

[DugzDMan]

What's the best way to insert, update, delete data before running a BO report?

I'm trying to get rid of some SAS reports that are realy hairy. I can picture a way to do it, by using some temp tables to combine data and then pull it all together into a report, but not sure about the best way to go about executing insert, delete, etc. statements.

Thx!

 

[skrandel]

BO doesn't work this way. You write queries and then you can filter your results.

I guess I'm not understanding what you're asking for. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[DugzDMan]

The reports I am trying to duplicate in BO are currently in SAS. The current code for the reports is 132 pages!! Believe me, it's been a headache figuring out everything it is doing. What I was wanting to do is to use some work tables and allow the DB to do much of the actual calculations then pull the data into BO to create the reports. If this isn't possible, I will try to do everything in BO, just wanting to check first. Any other ideas?

Thanks!

 

[blom0344]

It is quite well possible that doing a bit more work at the db side can simplify the BO report, but it is still within the limits of SQL. You may use SQL to aggregate or use decode or case to change values, filter data etc, but some things are better handled at the report level (such as grouping data (sections,breaks, group),calculations in contexts, adding calculated variables, ranking.

I have no knowledge of SAS, but the big development at the SQL side is the availability of OLAP functions at DB level (ranking ,etc) which allows you to process your data-set a bit more before creating the report on it.

But what do you mean by code in 132 pages? Are you using some kind of procedures for dataprovider? T. Blom
Information analyst
tbl@shimano-eu.com

 

[DugzDMan]

The data can't all be pulled in one query, it's just the layout and make up of the data and reports that won't allow this to be done. Actually, I guess it could all be done in one big query if I use sub selects (Select a, b, c from (Select d, e, f from ...)). How well does BO do on displaying reports using free hand SQL? I've done quite a few by designing a universe and pulling with those objects. I'm just not sure what would be the best way to go about this in BO.

Thanks for the help!

 

[blom0344]

There is no issue about BO having problems with free-hand SQL, other than you would miss some functionality that comes with the use of a universe as a DP, if the report is never customized with regards to the DP by a user you might go for a free-hand SQL. The report will work equally well with universe data as with a direct data-set from free-hand SQL`` T. Blom
Information analyst
tbl@shimano-eu.com