Sorry to be a pest - but I just thought I’d try posting this again in the hopes that someone might have missed it last time…
I’m involved in created some very complicated reports based on relatively simple queries. Extracting the SQL from the Query panel for both universe and user objects is no problem, but I’d really like to be able to somehow copy out all the logic behind my report variables/formulae, other than editing each one by one and copying out the formula. Does anyone have any idea if this is possible? It would certainly make it easier to reuse formulae (which can’t be duplicated by SQL for a user object) from report to report…
Thanks,
Amy Miller
====================================
Amy A. Miller, Data Analyst
University of Pennsylvania ISC
Office of Data Administration
3401 Walnut, Suite 265C /6228
Philadelphia, PA 19104-6228
Phone: 215-898-2171 Fax:215-898-0386
Email: milleraa@isc.upenn.edu
You may be able to acheive what you’re looking for by using Report Templates. Templates can contain variables and you can preserve them when applying a template to a new report. So, if you have alot of custom variables derived from a given set of objects, as long as those base objects exist in a new report, applying a template with your custom variables should render valid variables. Look at template options under Format => Apply Template [Options…] when viewing a report.
Hope That Helps,
Donald May
MIS Eagle Services
Pratt & Whitney
Ph: (860) 565-5253 Fax: (860) 565-4347 M/S: 117-35
E-mail: maydp@pweh.com
That would help for report standardization purposes, but I was also hoping to extract variable logic for documentation purposes. That is, I’d like to be able to document the logic for meetings with users when the invevitable “how did you get that number” comes up.
Thanks–
Amy
At 02:54 PM 9/29/98 -0400, you wrote:
Amy,
You may be able to acheive what you’re looking for by using Report Templates. Templates can contain variables and you can preserve them when applying a template to a new report. So, if you have alot of custom variables derived from a given set of objects, as long as those base objects exist in a new report, applying a template with your custom variables should render valid variables. Look at template options under Format => Apply Template [Options…] when viewing a report.
Hope That Helps,
Donald May
MIS Eagle Services
Pratt & Whitney
Ph: (860) 565-5253 Fax: (860) 565-4347 M/S: 117-35
E-mail: maydp@pweh.com
====================================
Amy A. Miller, Data Analyst
University of Pennsylvania ISC
Office of Data Administration
3401 Walnut, Suite 265C /6228
Philadelphia, PA 19104-6228
Phone: 215-898-2171 Fax:215-898-0386
Email: milleraa@isc.upenn.edu