COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: vincydza@gmail.com on 13 May 2019 01:15:40 pm

Title: Cube created Successfully but report show null values - Cognos transformer.
Post by: vincydza@gmail.com on 13 May 2019 01:15:40 pm
Hi,

The cube gets successfully created and deployed in Cognos transformer however when I create reports based on the cube it only returns NULL values. Like seen in the attached file.

What could be the issue.

Vincent
Title: Re: Cube created Successfully but report show null values - Cognos transformer.
Post by: MFGF on 13 May 2019 06:26:49 pm
Hi,

The cube gets successfully created and deployed in Cognos transformer however when I create reports based on the cube it only returns NULL values. Like seen in the attached file.

What could be the issue.

Vincent

If I had to guess, I'd assume the measure value is not in scope with the dimension(s)? Have you looked at the Scope Diagram in Transformer?

MF.
Title: Re: Cube created Successfully but report show null values - Cognos transformer.
Post by: vincydza@gmail.com on 13 May 2019 07:55:24 pm
Yes, I did check and confirmed that the measures are in the scope diagram in transformer.

Vincent

Title: Re: Cube created Successfully but report show null values - Cognos transformer.
Post by: vincydza@gmail.com on 13 May 2019 08:07:31 pm
see attached dimension map for details. The cube had no issue last week.  have no clue what happened today.

Vincent
Title: Re: Cube created Successfully but report show null values - Cognos transformer.
Post by: vincydza@gmail.com on 13 May 2019 08:20:29 pm
Could the suppression of "By All Dates"  category create an issue. See attached image.
Title: Re: Cube created Successfully but report show null values - Cognos transformer.
Post by: MFGF on 14 May 2019 12:50:16 pm
Could the suppression of "By All Dates"  category create an issue. See attached image.

Suppression of the drill category is normal (and expected) where you have multiple drill paths in a dimension. I can't see it causing this issue.

Cheers!

MF.
Title: Re: Cube created Successfully but report show null values - Cognos transformer.
Post by: vincydza@gmail.com on 14 May 2019 03:00:03 pm
MFGF,

I had created many reports prior to making the suppression of Root category change you had recommended on the earlier topic created on the forum.

I can take any of these reports  and  change it to add Year as the columns,  Customer as rows and measure as Units shipped. The report is good to go and retrieves  accurate data for the selected criteria.

However if i create a new report (cross tab)  based on the same cube and add Year as the columns,  Customer as rows and measure as Units shipped. It retrieves null values.

Why is it that reports created prior to this suppression change are good to go but reports created after this suppression change retrieve null values.

What  setups are missing in the changed cube.  Please advise.

Vincent
Title: Re: Cube created Successfully but report show null values - Cognos transformer.
Post by: adam_mc on 14 May 2019 03:26:41 pm
Are you in a multi-server environment?
If so, you will need to ensure that you are updating all versions of the cube.
Otherwise, it is possible that you are connecting to different versions of the "same" cube.

Just a thought.
Adam.
Title: Re: Cube created Successfully but report show null values - Cognos transformer.
Post by: vincydza@gmail.com on 14 May 2019 03:43:27 pm
This is not a multi server environment and before I could published the cube today to content store I had deleted the datasource and cube from the content store .

The possibility of connecting to different data source does not arise.

Vincent
Title: Re: Cube created Successfully but report show null values - Cognos transformer.
Post by: vincydza@gmail.com on 14 May 2019 06:24:01 pm
After further analyzing the issue i have reached a conclusion that any report created last week is good to go. However any new report created this week against the cube is returning null values.

MFGF is correct suppression of the root category has no impact on this issue. its just a coincidence

Any clues why the new reports created this week are returning null values.

Vincent