Output of WEBI report schedule in excel format fails to deliver

[former_member184512]

Hi,

we are on 4.0 SP2 P12.

we scheduled an webi report in excel format and provided all information in destination. we mentioned specific name for attachment as

If I select "use automatically generate name" then report delivery in excel format is good.

But if i select "use specific name" as above then out as below

Its not delivering in excel format, Not sure why its happens like that.

Thanks

Thanks

[michael_melters · Accepted solution]

If you generate a specific name you should add "." and the placeholder "file extension". Then your wrong windows symbol should be replaced by an excel symbol showing that the right format is delivered.

[former_member184512 · Accepted solution]

Hi,

Right now I am using %SI_NAME% - %SI_STARTTIME% in the place specific name path(1st screen shot give more picture)

So now where do u want me add "." in the path?

your reply  will be helpfull to me

Really I did not what should add "." and the placeholder "file extension" it mean?

[michael_melters · Accepted solution]

It is the very last entry in the placeholder dropdown:

If complete with, so with "." before, it looks like:

%SI_NAME% - %SI_STARTTIME%. %EXT%

Then your  attachment should have a symbol indicating that the document is in Excel format and not a windows symbol.

[former_member184512 · Accepted solution]

Hi Michael,

Thanks a lot...

I have another question for you..

Now we are planning to schedule an reports.

1. we have X report in A folder, where all users have an access to this report . we have 50 users

2. Now users want to schedule report with there own prompts selection(prompt selection differs to each users)

3. If user schedule an X report from A folder then  each and every user are able to see all instance in history because they have access to report. Which we do not want to make it. We want to make sure that user should not see other user instances.. could you let me know how to do it?

My proposal to team:

1. Let us ask users to copy X report in there personal folders and ask them to schedule it according to there wish and we as admins will make sure that user can maintain only 5 instances for report.

2. but problem what we have in that is, if 50 users copy X report into their personal folders then extra 50 reports are taking space.. how to avoid it?

please could you help me out to come over this issue??

Thanks in advance

[michael_melters · Accepted solution]

Create an access level "View only own instances" based on predefined Access Level "View" set the right "View Instances" from status "Granted" to "Not specified". Apply that access level to folder where you don't want the users to see instances from other users. Make shure that the right "View instances that the user owns" remains in "Granted" status.

By  that every users can only see his own instances.

[former_member188911]

what do you mean with "it is not delivering" do you get errors? 

have you checked the outbox of the email server, its logs etc?

thanks

[former_member184512]

Hi Experts,

I am waiting for your inputs on issue. Please help us out.

Thanks