Cognos 10 - Determinants


We have an issue where we have student Majors and Major Reporting categories.  The problem is that these items have a 1.N <--> 1.N relationship.  Currently on the back end the database has these items stored together in the same view (as our FM model source) and there is no unique key defined for each reporting category (it has to be a combination of the Major_Code + Reporting_Category).  With this being the case can  determinants be used to correct the granularity.  I have attempted this by defining Major as the first determinant with Major_Code as the key and then Reporting Category as my second determinant with a derived key of (Major_Code + Reporting Category).  I was able to compile this into my model on the Major dimension and successfully publish the package.  However, the report I built returned the same exact GPA value I was getting in the report prior to incorporating determinants.

I have looked at the documentation from IBM and found it to be less than useful.  Can anyone recommend better documentation source or provide personal experience using determinants.  

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ktQueBITAuthor Commented:
Quick question.  Does the data  have to be truly hierarchical for determinants to work?  As I mentioned above this data has a many to many relationship.
ktQueBITAuthor Commented:
Found out that determinants would not work due to relational database design and data relationships.  We were required to redesign the back end tables and rework FM to get this to work correctly.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ktQueBITAuthor Commented:
Turned out to be the best solution (reworking the back end) because under old data warehouse design data relationship would not work.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.