No data on first run when chaging parameters

[Ludijak]

I am currently working on a report that has an issue that each time parameter is changed from default value and repromt is done it returns no data, but on second repromt data is returned as expected.

My conclusion is that on the first repromt data items use default values of parameters instead of chosen ones and on second repromt it uses chosen ones. Data item is using macro for getting prompt values.

I don't have any idea how to fix this. I tried all the options I could find about caching on the report as I thought that parameter caching is the issue, but that didn't change anything.

Report model is dimensional and data is filtered in a way that in data item for those values is inserted value from prompt.

If there is any additional info that is needed feel free to ask. I would appriciate any help with this.

[MFGF]

I am currently working on a report that has an issue that each time parameter is changed from default value and repromt is done it returns no data, but on second repromt data is returned as expected.

My conclusion is that on the first repromt data items use default values of parameters instead of chosen ones and on second repromt it uses chosen ones. Data item is using macro for getting prompt values.

I don't have any idea how to fix this. I tried all the options I could find about caching on the report as I thought that parameter caching is the issue, but that didn't change anything.

Report model is dimensional and data is filtered in a way that in data item for those values is inserted value from prompt.

If there is any additional info that is needed feel free to ask. I would appriciate any help with this.

Hi,

I assume you are using your parameter in a data item that targets the correct MUN to retrieve from the cube, rather than using a detail filter? This would be the correct approach. You also mention you are using a macro - so I'm assuming that means you are using either prompt() or promptmany()? What arguments are you using within the function? Can you share an example of the dimensional expression in your item that includes the macro? We could then figure out what default is being used, and try to compare it with the real MUNs in your source to see if it is formatting the expression correctly.

Cheers!

MF.

[Ludijak]

Hi,

thank you for reply. Your assumptions are correct. I am using prompt() to get parameter value in Data item for period. That period Data item targets correct MUN to retrieve from the cube. All this is working as expected and there wasn't any issue with this report regarding data in the report.

I'll try to explain better what is the issue. Let's simplify and say I have two prompts, one for period and second for customer. Default value for Period is current period (that would be 202311 now) and default value for Customer is All.

Report is set to automatically run with default parameter values and everything is working as expected. When I change only period and repromt everything is OK, when I change only customer from all to specific it is also working as expected. But when I change both customer from all to specific (let's say A) and period to any other no data is returned on reprompt. Both prompts are single select. All is on the same level as specific customers.

Now what is interesting is that when I repromt second time with same parameters everything is working as expected.

[MFGF]

Hi,

thank you for reply. Your assumptions are correct. I am using prompt() to get parameter value in Data item for period. That period Data item targets correct MUN to retrieve from the cube. All this is working as expected and there wasn't any issue with this report regarding data in the report.

I'll try to explain better what is the issue. Let's simplify and say I have two prompts, one for period and second for customer. Default value for Period is current period (that would be 202311 now) and default value for Customer is All.

Report is set to automatically run with default parameter values and everything is working as expected. When I change only period and repromt everything is OK, when I change only customer from all to specific it is also working as expected. But when I change both customer from all to specific (let's say A) and period to any other no data is returned on reprompt. Both prompts are single select. All is on the same level as specific customers.

Now what is interesting is that when I repromt second time with same parameters everything is working as expected.

Hi,

That sounds like odd behaviour. Can you post up an example of the expression you are using?

Cheers!

MF.

[dougp]

If you have set both prompts, why would you click Reprompt?  Maybe you need to click Finish.

[Ludijak]

Hi,

thank you all for your insights. I didn't find solution as the issue was that one parameter was depending on another and this would never be able to work without repromt + finish combo which user did not want.