Cognos 10 - Determinants

Posted on 2014-08-18
Last Modified: 2014-09-10

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.  

Question by:ktQueBIT

    Author Comment

    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.

    Accepted Solution

    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.

    Author Closing Comment

    Turned out to be the best solution (reworking the back end) because under old data warehouse design data relationship would not work.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now