I have a use case in front of me right now:
I want to quickly create a business schema table/view by dragging and dropping the physical schema table. Can do.
I need to add some CASE logic to the values based on a lookup code ( e.g. if LU=1 then 'blah', if LU=2 then "de", else "blahblah" )
I should be able to open an expression editor for every column and modify it's default mapping to include whatever calculation I need instead of having to individually create formula columns for them.
Note: It's not that the end result can't be created - it can. But it would be so much more powerful to be able to edit existing things than having to replicate, modify, and delete the originals.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.