disable refresh option for Excel based data in BGusiness Objects

[ethan1701]

Hi,
I have several reports, where one of the data providers is an excel file, and I do not wish to refresh this rpovider with every refresh to the file. However, the Refresh checkbox on hte provider (in the Data Manager windows' Definition tab) is disabled, and checked. I have other reports where the checkbox is not disabled, and I have no idea what's disabling the checkbox!!

I desperately need help solving this problem! Has anyone else ever encountered this problem?

-Ethan

 

[Sridharan]

Login to BO with the same user who created that report and check the settings and uncheck the Checkbox and save the report...

Sri

 

[ethan1701]

Sri,
What settings should I check? the file properties? no author there... I created all the filed I'm dealing with here...
I wish I could uncheck the checkbox...

-Ethan

 

[skrandel]

The settings are in the data viewer. Data->View Data (I think). Select a data provider and look at the Definition tab. From there you can adjust the settings.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[ethan1701]

I looked over there, and that's exactly the problem! I made a screenshot of the problem, you could see it here:

http://www.madab-il.com/BO.GIF

Like you can see, the checkboxes are disables, and I have no idea why, or how to uncheck them...

-Ethan

 

[skrandel]

Are you the owner of the BO Document. It sure seems like it's opened in a read-only mode. Try doing this with a General Supervisor ID.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[ethan1701]

I am in fact the owner of the document (I created it) I only have this problem with reports that incorporate an Excel file, though in this case, both data-providers are non-editable...

 

[Sridharan]

Ethan,

If you are the creator of the Document then you should be able to modify the property... If not login as a General Supervisor and then open the BO Document and then modify the property in the Data Manager...

Sri

 

[skrandel]

What version are you running? I'm not experiencing this with 5.1.6. I'll try it on 6.1b.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[ethan1701]

I'm using version 5.1.3

 

[skrandel]

Perhaps the version is the problem.

5.1.3 is quite possibly the most unstable release of the last few years. All I can tell you is that it works on more current versions. Perhaps you should upgrade on one machine and see if that resolves your problem. At least you'll know.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[ethan1701]

Hi, aparently, the version isn't the problem. I got an answer on a forum:

http://www.forumtopics.com/busobj/viewtopic.php?p=128058#128058

that said:
Do a "Save As...", check "Save for all users". Then try to uncheck the box in question.

This did in fact solve the problem.

Thank you guys for trying. I hope that if anyone ever has this problem in the future, this post will help.

-Ethan

 

[blom0344]

It may solve the problem sort-of, but effectively all security is removed from the document as well.
The 5.1.3 version on my laptop does not show this problem when tested (and stability seems to be an issue even with 6.1 )

T. Blom
Information analyst
tbl@shimano-eu.com

 

[skrandel]

But, what happens if you then publish the document? Will you have to do this again?

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[ethan1701]

Why would I have to do this again?

 

[Sridharan]

Well when one opens the report with GS ID which can do anything then I was able to modify the properties... Thats how it worked for me at my side... So when you did a Save For All then everyone gets the privileged... Glad it worked for you...

Sri

 

[skrandel]

If Save For All fixed the problem, then it should come back if you ever need to change this attribute. Safe For All users simply removes the security bit from the reports. Then the report doesn't think it's ever existed in the repository.

The General Supervisor ID likely would/should have been able to resolve this for you.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com