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

(Cube+RS)Date Parameter Display Issue

Started by Arsenal, 20 Dec 2007 10:26:48 AM

Previous topic - Next topic

Arsenal

Hi,

We have drill through reports that are accessed via summary reports which run off a cube. The data range is selected in Analysis Studio and then a drill through is activated.

Now, our date dimension is a fiscal kind of dimension - certain months end before 31st or 30th, the remaining days are rolled over into the next month and so on. This we have achieved by manual addition and deletion of categories.

So now, for example, April starts on 3/26 and goes through 4/28. When April is selected in Analysis Studio and dril through, then the paramdisplay calculation in the drill through report header always seems to display 4/01 - 4/28, evethough records for 3/26, 3/27 etc are being pulled in. We have gone through every category definition - month of April beginning on 0330 etc. in Transformer. Everything is set the way it should.

Other months also show this problem. The problem is just with the beginning date display. The ending date always shows correctly.

Any suggestions would be gratefully welcome. Thanks

MFGF

Hi,

This sounds like an "undocumented feature".  :)

To get the correct heading, you could try changing your approach a little.

I'm assuming that in the report you are drilling through to, you are coding an expression to retrieve your dates from the cube as follows:

children([your month level] -> ?month?)

and then you are passing in the month value to the parameter when you drill through?

Instead of coding a layout calculation for your page heading, you could instead add a repeater object which displays a query calculation as follows:

openingPeriod([your day level],[your month level] -> ?month?)

Then add a second repeater containing the following query calculation:

closingPeriod([your day level],[your month level] -> ?month?)

This should allow you to display the first and last day member belonging to your passed month as part of your page heading.

Does this help any?

Best regards,

MF.
Meep!

Arsenal

MFGF,

As always, thanks for your reply.

The drill through report is a relational one i.e. off the Framework Manager model. The summary runs off the cube.

In the drill through report, the fillter is something like [querysubject]...[date] in_range ?date? and it is an optional filter