create a business layer and a database layer in one unv

building semantic layer
1

I want to create a Business Layer in IDT where objects are named and storred in classes in such way they make sense to end users

In that same universe I want to create a Master Data Layer where objects are named and stored according to the tables in the original database (so a class for each table and objectname = column name)

After the two layers are created I want to set security on them, end-users only see Business Layer and Administrators can see both.

I’m looking in IDT but the only way to realise this is to copy objects but that’s not very economical. Is there a way to create some sort of short-cut object so it’s referring to the original and if it changes it automatically changes with the original? Is there a best practice for the above question?

Tiny :netherlands: (BOB member since 2004-11-10)

2

You mean like the @Select() function?

Dave Rathbun :us: (BOB member since 2002-06-06)

3

good thinking dave, but the @select still doesn’t transfer, description, format from the original object so that’s still not very economical…

I’m also figuring out what’s the big deal about those layers in IDT? Its just hiding classes and objects in a fancy way

(nothing new, we could also do this in Designer, but not that fancy)

Tiny :netherlands: (BOB member since 2004-11-10)