framework modeling

[nfldbunker]

hi

just wondering if someone can provide some information if this is possible. I have a table which contains  a lot of information related to a patient and one of these fields is location field(Institution). I want to use the institution in a table by itself and then users can open up the institution and bring this in as a field on the report. I dont want it left in the main patient table.

Any ideas or help would be appreciated.

regards

bunker 

[MFGF]

Hi,

You should be able to base two new model query subjects on the original data query subject used to retrieve patient information into the model.

Call one of them Patient Info (or similar) and bring into it all the items from the underlying query subject except for the location.

Call the second quier subject Institution, and bring just the Location field into this one.

Make these two query subjects visible in your package.

Does this give you what you need?

MF.

[nfldbunker]

Can Any SQL data set be molded into a star schema?

[MFGF]

Yes absolutely - this is actually what the best-practice modelling guidelines suggest you should do to achieve accurate, consistent results.

MF.