This is a discussion on How to add "reference calculation" columns in design tables? within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hello I have created a design table and want to add columns within the table that DO NOT drive ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello I have created a design table and want to add columns within the table that DO NOT drive any dimensions but are there as "reference" numbers to assist any user editing the design table. eg. a calculated column that tells the user what the maximum dimension can be for the dimension referenced by the dimension driving cell next to it. I think I can recall doing something like this in the past and perhaps used some syntax that used the term "statement". Thanks in advance. Bullman |
| ||||
| Bullman wrote: > Hello > > I have created a design table and want to add columns within the table > that DO NOT drive any dimensions but are there as "reference" numbers > to assist any user editing the design table. > > eg. a calculated column that tells the user what the maximum dimension > can be for the dimension referenced by the dimension driving cell next > to it. > > I think I can recall doing something like this in the past and perhaps > used some syntax that used the term "statement". > > Thanks in advance. > > Bullman I have no idea what you are trying to do. If you want to add columns then add them. What's this issue? Though in a relational design I would expect that what you need is a second table that could be referenced as a lookup. You will need to be far clearer in your explanation: At least for me. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org |