Related to AFO user variant

[former_member456005]

Hi,

One of our user has created report based on Analysis for Mircosoft office Excel. He has create one user variant. And that report is running successfully fine. But when he tries to schedule that report that saved user variant is not appearing in prompt tab of drop down list. And to fill that prompt he has to do it manually ? He always get error message, that Workbook contains no OLAP connection. Could you please help on it..

[denis_konovalov]

what have you done so far to investigate the issue ?

[former_member456005]

Now issue got resolved. I have crated user variant and saved it. Also in Design panel- Component tab I set properties as 'force prompt as initial refresh' and saved my workbook. After that user variant I can see in dropdown list while scheduling AFO. Same I have explained to user.