OLAP 2 Relational DrillThru

[Sumeru]

Hello Folks,
I am developing a report based off of the cube with 4 charts in,meant to be a dashboard. so, my issue is, i should be able to drill thru to detailed report which is a relational one, upon clicking on a value in barchart.my bar chart is like having sales over a period of 30 days,so when a user clicks on lets say '50'(sales) units sold on 11/15/2011 it should take them to detailed report how those 50 units are distributed over product lines.
in both the sources(OLAP & Rel) the date format is like '2011/12/21',but still it threw me this error...."Expected format for date: CCYY-MM-DD.RSV-SRV-0042"

so i changed the date format accordingly in target report,but this time instead of error report runs but with no data. and i used layout calc to see if it is passing any values at all and i can see the date that i selected in source report. but it is not filtering accordingly in target report.

any ideas where i'm going wrong?

[MFGF]

Hi,

You need a detail filter in your target relational report that uses a date/time column and the 'in_range' operator

Eg.  [Your date time column] in_range ?Your date param?

The drill through will automatically convert your OLAP date member into a suitable format to fulfil this parameter.

Regards,

MF


Snet form my fumblefingers
iPhon 5 usig Tapatalk

[cognostechie]

The date format in OLAP will never be '2011/12/21' because it will a MUN but you shouldn't have to worry about it. In the Target report which is using a relational package, try this in the filter -

[Date column] in_range ?Date Parameter?

This way, even if you have a higher level like Months in Bar chart, the drill thru will still work whether you drill thru from a higher level or a lower level like Days.

[cognostechie]

Holy Moly ! Your reply went in when I was typing  ;)

[Sumeru]

Well i actullay had a prompt in my target report.so it was actually expecting a date of format CCYY-MM-DD, so i changed the date type in target report to match the format its expecting.it worked but only to an extent to see a chart with no data in it.
if i run target report alone and when i pass the date values in string format i see data for those dates.

[Sumeru]

Folks, do i need to check "Allow drill through for this PowerCube" option in Transformer PowerCube properties?

[cognostechie]

No, you don't need to, that's different.  The data type for Date should be Date and you shouldn't have to change the format.

[MFGF]

Well i actullay had a prompt in my target report.so it was actually expecting a date of format CCYY-MM-DD, so i changed the date type in target report to match the format its expecting.it worked but only to an extent to see a chart with no data in it.
if i run target report alone and when i pass the date values in string format i see data for those dates.

The formatting in the target report is irrelevant - what's important is simply that it is held as a relational date/time value. If it is a string, you will not get the date value(s) to pass in correctly from your source report.

Cognostechie, I was reading your thought waves and typing at full speed to get my answer in before you could hit Send! ;)

MF.


---
Sent from my iPad using Tapatalk

[cognostechie]

Cognostechie, I was reading your thought waves and typing at full speed to get my answer in before you could hit Send! ;)

MF.


---
Sent from my iPad using Tapatalk

All right then, I will remember this for the future. I am writing a code that will capture your reply, hold it for a few minutes and then post it . That way I will always be ahead of you  :)

[Sumeru]

Thanks for your time MFGF and CogTechie, mine was such a simple and silly mistake.i overlooked a relational function being used in the report and deleting it made the report to work fine.