Crosstab / Data Cube Refresh Issue [message #518638] |
Thu, 04 March 2010 11:50 |
Eclipse User |
|
|
|
Originally posted by: bbeaulieu2.quillings.com
I'm having an issue where a report I'm developing needs to have a crosstab within a table. The table has a list of regions and the crosstab needs to show a summary of incidents reported to a service desk for that particular region. I want to be able to pass in the region to the dataset, but there doesn't appear to be any provisions for this when crosstabs are used. So instead I've tried to place the crosstab into a grid, and I have the grid pass in the region from the table so that the data set will be (theoretically) refreshed.
I've created the table, and the table shows the regions correctly. I've created the grid and placed the crosstab inside the grid so that the dataset gets the region parameter. However, the crosstab does not refresh when the report is run. Instead, it show only the default parameter for the data set.
So, either one of two things is happening. Either the data set is getting called once and never refreshed or the data set is getting called multiple times but is never receiving the input parameter. Looking at the debug output of the report, it appears to me that the data set is getting called only once and then is being displayed multiple times with the *same* data.
Anyone have any thoughts on this issue? Any idea how to pass an input parameter to a data set via a crosstab and have it refresh/update inside of a table?
Thanks for your thoughts,
Brad Beaulieu
bbeaulieu2@quillings.com
|
|
|
Re: Crosstab / Data Cube Refresh Issue [message #519056 is a reply to message #518638] |
Fri, 05 March 2010 22:28 |
|
Brad,
Cubes by default are only created once. We are looking into some
improvements on the cubes, but you could take the parameter off the
dataset and then put a filter on the crosstab for the specific region.
Jason
Brad Beaulieu wrote:
> I'm having an issue where a report I'm developing needs to have a
> crosstab within a table. The table has a list of regions and the
> crosstab needs to show a summary of incidents reported to a service desk
> for that particular region. I want to be able to pass in the region to
> the dataset, but there doesn't appear to be any provisions for this when
> crosstabs are used. So instead I've tried to place the crosstab into a
> grid, and I have the grid pass in the region from the table so that the
> data set will be (theoretically) refreshed.
>
> I've created the table, and the table shows the regions correctly. I've
> created the grid and placed the crosstab inside the grid so that the
> dataset gets the region parameter. However, the crosstab does not
> refresh when the report is run. Instead, it show only the default
> parameter for the data set.
>
> So, either one of two things is happening. Either the data set is
> getting called once and never refreshed or the data set is getting
> called multiple times but is never receiving the input parameter.
> Looking at the debug output of the report, it appears to me that the
> data set is getting called only once and then is being displayed
> multiple times with the *same* data.
>
> Anyone have any thoughts on this issue? Any idea how to pass an input
> parameter to a data set via a crosstab and have it refresh/update inside
> of a table?
>
> Thanks for your thoughts,
>
> Brad Beaulieu
> bbeaulieu2@quillings.com
|
|
|
Re: Crosstab / Data Cube Refresh Issue [message #519066 is a reply to message #519056] |
Fri, 05 March 2010 23:25 |
Eclipse User |
|
|
|
Originally posted by: bbeaulieu2.quillings.com
That's perfect, Jason. Thanks so much for the assistance.
Brad.
Jason Weathersby wrote:
> Brad,
>
> Cubes by default are only created once. We are looking into some
> improvements on the cubes, but you could take the parameter off the
> dataset and then put a filter on the crosstab for the specific region.
>
> Jason
>
> Brad Beaulieu wrote:
>> I'm having an issue where a report I'm developing needs to have a
>> crosstab within a table. The table has a list of regions and the
>> crosstab needs to show a summary of incidents reported to a service
>> desk for that particular region. I want to be able to pass in the
>> region to the dataset, but there doesn't appear to be any provisions
>> for this when crosstabs are used. So instead I've tried to place the
>> crosstab into a grid, and I have the grid pass in the region from the
>> table so that the data set will be (theoretically) refreshed.
>>
>> I've created the table, and the table shows the regions correctly.
>> I've created the grid and placed the crosstab inside the grid so that
>> the dataset gets the region parameter. However, the crosstab does not
>> refresh when the report is run. Instead, it show only the default
>> parameter for the data set.
>>
>> So, either one of two things is happening. Either the data set is
>> getting called once and never refreshed or the data set is getting
>> called multiple times but is never receiving the input parameter.
>> Looking at the debug output of the report, it appears to me that the
>> data set is getting called only once and then is being displayed
>> multiple times with the *same* data.
>>
>> Anyone have any thoughts on this issue? Any idea how to pass an input
>> parameter to a data set via a crosstab and have it refresh/update
>> inside of a table?
>>
>> Thanks for your thoughts,
>>
>> Brad Beaulieu
>> bbeaulieu2@quillings.com
|
|
|
Powered by
FUDForum. Page generated in 0.03755 seconds