Tuesday, March 20, 2012
Bug: default value showing as query based when it is not (report m
The default value is not queried, this is just set to "=1".
When the report is deployed, the parameter in report manager is showing as
'query based' which is wrong.
This is a pain in the ass as when I try linking to this report, I am not
able to set the value to something else.If you use a query to specify a range of parameters then it seems to show
default as 'query based' in the report manager.
What I have discovered is that if you change something to do with the
parameters on the report and redeploy, you can pick up the changes in the
linked report by repointing the linked report at the same report, this forces
some kind of refresh to occur and although very annoying, is easier than
recreating the linked report.
<despair>Thanks to MS for providing a UI of such high quality.</despair>
"adolf garlic" wrote:
> I have a report which uses a query to populate a parameter.
> The default value is not queried, this is just set to "=1".
> When the report is deployed, the parameter in report manager is showing as
> 'query based' which is wrong.
> This is a pain in the ass as when I try linking to this report, I am not
> able to set the value to something else.
Friday, February 24, 2012
Browsing cubes through interfaces other than the BI Studio?
I've built a cube, deployed it and processed it. I can use the brower in the BI Studio to see the data subsets and can manipulate it. How do I get this cube to the user without having to install BI Studios on their computer?
Basically how do I get the cube into IIS so the user can just open a web browser and go to it? Similar to how cognos does it with their cubes. Or is this not possible?
I see no way to view the cube unless you are using the BI Studio to open it. Am I missing something?
You are indee missing quite a lot.
There are many different ways to browse a cube using different applications. Just to name a few: Excel, Office Web Components ( you see it embedded in BI Dev studio), ProClarity, and many others.
After building a cube you should decide on the way you going to let your users to browse a cube data. Take a look at client application and evaluate which one works for you the best and then deploy it on client machines.
Try out a new PivotTables in Beta of Office2007.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Could you point me to some documentation on or the correct direction to being able to view the cubes through a web interface? I'd like to be able to use strictly Server 2003 and SQL 2005 and be able to deploy these cubes to IIS for viewing without the use of a third system or special installations on PCs.
So with that in mind I'd like to be able to view these cubes from any computer that has an Internet explorer window.
|||For instance take a look at this one http://www.proclarity.com/products/proclarity_for_sharepoint.asp
And this one http://www.panorama.com/products/nova_view_dashboards/index.html
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Take a look at this one:
http://www.beyond2020.com/products/vista_overview.php
For a demo:
http://www.beyond2020.com/products/demo.php
Sunday, February 19, 2012
Broken Images and Charts in Deployed Reports
Does anyone know why on some installations of RS, using the Reports Viewer
(http://localhost/Reports/), all images and charts appear to be broken, but
if exported, work fine. Using ReportServer works, but its not very
user-friendly for our clients.
I only read a couple of posts about this issue, but couldnt find an answer.
Some people said that if you enable Allow All Cookie's in IE, it works... but
why then is this problem only occuring on some installations of RS?
The one major differance I can point out is that it seams that broken images
only occur on Servers (Win2003) but not on development (XP) computers... Is
this as simple as an IIS issue, or security perhaps?
Please help! I'm sure there are many others with the same issue!
Thanks,
AndreAnswer is simple, and stupid...
IE does block the cookies from the RS website for some reason.
There are two fixes I know.
1) Inform anyone using RS to find the security icon at the bottom of IE and
right click it and allow Cookies from that site.
2) Inform anyone using RS to go to IE security and turn of automatic
handling of cookies and allow all cookies... I dont think this is quite hte
best idea though.
Andre
"Arkiliknam" wrote:
> Hi all,
> Does anyone know why on some installations of RS, using the Reports Viewer
> (http://localhost/Reports/), all images and charts appear to be broken, but
> if exported, work fine. Using ReportServer works, but its not very
> user-friendly for our clients.
> I only read a couple of posts about this issue, but couldnt find an answer.
> Some people said that if you enable Allow All Cookie's in IE, it works... but
> why then is this problem only occuring on some installations of RS?
> The one major differance I can point out is that it seams that broken images
> only occur on Servers (Win2003) but not on development (XP) computers... Is
> this as simple as an IIS issue, or security perhaps?
> Please help! I'm sure there are many others with the same issue!
> Thanks,
> Andre