If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill through from cube to report throught time dimension

Started by jriego, 27 Jan 2010 10:57:03 AM

Previous topic - Next topic

jriego

Hi,

we are trying to create a report with thrill-throught capability from a cube.

The time dimension that was generated in the cube is based on the movement_date column and has the following formats for every level:

YEAR: YYYY
MONTH: YYYY/MMM
DAY: YYYY/MM/DD

The parameter was added to the prompt page as a date and with the in_range operator. The strange part is that when the query is executed in teradata it takes something similar to this form:

...
WHERE movement_date BETWEEN '009/01/2' AND '009/01/2'
...

You can notice that the dates are truncated on both sides.
Does anybody have an idea on what should we change?

Thanks and regards.

MFGF

Hi,

I recall issues like this in earlier builds of 8.4.  What version are you on currently?

MF.
Meep!

jriego

Thank you for the fast response MF.

We are using the version 8.4 in the report studio and the 8.4.2286.0 for the transformer.

It looks like there is some kind of bug but right now there is not going to be an intervention in the server. Because of that we need a workaround or some justification that it is not possible to solve it.

Any pointers you could give us would be of great help.

Best regards.

MFGF

I know for sure it is fixed in 8.4.1.  Are you in a position to upgrade to this release?

MF.
Meep!

cemakpinar

Quote from: MFGF on 29 Jan 2010 05:36:12 AM
I know for sure it is fixed in 8.4.1.  Are you in a position to upgrade to this release?

MF.


Got the same problem here, running on cognos 8.4.27.78-0
I hoped the fix pack 2 should do the trick, but it's not solved.

@MF
We are not in a position to do a upgrade(8.4.1). Do you no another option?  Cognos hotsite?