| Author |
 Topic  |
|
|
vane307
Argentina
25 Posts |
 Posted - 08/25/2010 : 08:19:39
|
Hi!
I want to know if it is possible pre execute a report. Like a snapshot, but if it possible schedule a snapshot.
I also want to know when I'm creating a report, if there is any option that allow me desing the report, but it doesn't excecute at the same moment that I'm designing it.
Thanks
Regards, |
|
|
admin
1637 Posts |
Posted - 08/25/2010 : 13:36:59
|
Yes, you can pre-execute a report by creating a report subscription with delivery type = Snapshot.
In OLAP Report design mode, click the MDX button - the MDX panel will open. Now when designing the report, it will not execute. Click Build button to build MDX and click Execute button to execute the MDX. |
 |
|
|
vane307
Argentina
25 Posts |
Posted - 08/26/2010 : 11:11:32
|
Thanks!!  |
|
|
|
vane307
Argentina
25 Posts |
Posted - 09/02/2010 : 18:02:12
|
Hello!
I was trying to create a report subscription with delivery type = Snapshot to pre-execute a report, but I've obtained teh next error: No data is returned.
Can you help to do it?
Regards,
|
|
|
|
admin
1637 Posts |
Posted - 09/02/2010 : 23:03:59
|
Do you get data when you select Delivery Type = Attachment?
What is the MDX returned? Does this MDX return result when you run it against SSAS?
|
|
|
|
vane307
Argentina
25 Posts |
Posted - 09/06/2010 : 13:10:09
|
Hi,
It also doesn't work when I selected Delivery Type = Attachment, I obtained the same error.
I tried to run the MDX against SSAS and I obtained results.
Do I have to do any extra setting to do this??
Regards, |
|
|
|
admin
1637 Posts |
Posted - 09/06/2010 : 20:13:13
|
Do you use Anonymous authentication only on the XMLA virtual directory?
Please go to Admin >Schedules and create "URL Trigger" type of schedule. Next, open your subscription and select the schedule you just created. Go back to Admin >Schedules, select the Schedule and click "Test".
|
|
|
|
vane307
Argentina
25 Posts |
Posted - 09/07/2010 : 11:37:41
|
Hi,
I'm using both Anonymous authentication and Windows Authentication on the XMLA virtual directory.
I created an "URL Trigger", then I selected on my suscription the schedule I just created . After I selected the Schedule and click "Test", I obtained a new window with an 'OK', but on the History Tab for the suscription, I'm still having the same error "No data is returned"
Regards, |
|
|
|
admin
1637 Posts |
Posted - 09/07/2010 : 19:30:25
|
| Please try to use Anonymous authentication only. |
|
|
| |
Topic |
|
Report Portal
pre execute a report
