Aggregate Virtual column in master file.

[devendrap]

I am new to Webfocus. Can I add aggregate column in the Master file?

Eg. Sum(tablename.columname)

I would like to use the same column in multiple reports.

Thanks

 

[jimster06]

When you say 'MASTER FILE,' are you referring to the synonym or master file description? Or are you talking about extracting data for subsequent use in reports?
If the latter, consider using a multi-verb request. Consider also the use of the TOT. prefix.
I would urge caution regarding including an aggregate total in a 'MASTER FILE' because of the volatility of the data.
Consider also getting some training in the use of WebFOCUS.

 

[devendrap]

Thanks for your reply...

I am coming from BusinessObjects world. I was thinking to make most of the joins and calculations at metadata (or master file or synonym) so It can be reused for reports.

 

[jimster06]

If you are building a HOLD file using native SQL then what you are proposing should work for you.