[Webinar] Learn how to a build a cloud-first strategyRegister Now


Cognos 10 - Determinants

Posted on 2014-08-18
Medium Priority
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
  • 3

Author Comment

ID: 40268555
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

ktQueBIT earned 0 total points
ID: 40315639
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

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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
What we learned in Webroot's webinar on multi-vector protection.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

867 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