Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Separate projects to support datamarts?

Separate projects to support datamarts?

Separate projects to support datamarts?


We have a project which is quite big and contains lots of reports. We plan to spit this up into separate reporting areas by subject and have separate projects for each subject area. However these datamarts share a lot of the same dimensions. Is there a way to have a core project which contain the schema description for the enterprise-wide data warehouse and separate datamart projects which just contain public object and are linked to the core project for the schema?

Has anyone else found a good solution for handing datamarts without having to manage load of different sets of metadata?

Regards, Saf

RE: Separate projects to support datamarts?

The only thing I can think of is to have one core project that just contains all schema objects that you use as a source for the other two projects. Whenever you make a change to a schema object you then copy it to both of the other projects. Not a great solution but I haven't heard of any other way of doing it. If it's not critical you could always have just one project and then put your subject areas into different folders. You could then use security to determine who gets to see which subject area.

RE: Separate projects to support datamarts?

This was the conclusion I had reach too. Thanks for the advise.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close