We have successfully generated a Report Model against a Cube data source. My question is I can't seem to figure out how to modify the model. The wizard organized and named entities in an odd way - and even finding the measures is in some obscure place. I know how to create models in BIDS, but it doesn't seem to give me that same flexibility against a cube source.
unfortunately you can't edit it using VS.
maybe you can manually edit the XML file behind the model... but its a huge job...
"Joe" <hortoristic@.gmail.dot.com> wrote in message news:7FE0118E-8DD0-4D77-B39A-024254A0C10E@.microsoft.com...
We have successfully generated a Report Model against a Cube data source. My question is I can't seem to figure out how to modify the model. The wizard organized and named entities in an odd way - and even finding the measures is in some obscure place. I know how to create models in BIDS, but it doesn't seem to give me that same flexibility against a cube source.
Showing posts with label successfully. Show all posts
Showing posts with label successfully. Show all posts
Wednesday, March 21, 2012
Report Model against Cube data source
We have successfully generated a Report Model against a Cube data source. M
y question is I can't seem to figure out how to modify the model. The wizar
d organized and named entities in an odd way - and even finding the measures
is in some obscure place. I know how to create models in BIDS, but it does
n't seem to give me that same flexibility against a cube source.unfortunately you can't edit it using VS.
maybe you can manually edit the XML file behind the model... but its a huge
job...
"Joe" <hortoristic@.gmail.dot.com> wrote in message news:7FE0118E-8DD0-4D77-B
39A-024254A0C10E@.microsoft.com...
We have successfully generated a Report Model against a Cube data source. M
y question is I can't seem to figure out how to modify the model. The wizar
d organized and named entities in an odd way - and even finding the measures
is in some obscure place. I know how to create models in BIDS, but it does
n't seem to give me that same flexibility against a cube source.
y question is I can't seem to figure out how to modify the model. The wizar
d organized and named entities in an odd way - and even finding the measures
is in some obscure place. I know how to create models in BIDS, but it does
n't seem to give me that same flexibility against a cube source.unfortunately you can't edit it using VS.
maybe you can manually edit the XML file behind the model... but its a huge
job...
"Joe" <hortoristic@.gmail.dot.com> wrote in message news:7FE0118E-8DD0-4D77-B
39A-024254A0C10E@.microsoft.com...
We have successfully generated a Report Model against a Cube data source. M
y question is I can't seem to figure out how to modify the model. The wizar
d organized and named entities in an odd way - and even finding the measures
is in some obscure place. I know how to create models in BIDS, but it does
n't seem to give me that same flexibility against a cube source.
Tuesday, March 20, 2012
Report Manager returning a 500 error
Hi,
So here's what happened. I had successfully deployed an ASP.Net
application, had it running and using SQL 2K5 reporting services just fine.
I rolled out an update to the application, and included an UpdatePanel in a
few of the pages (nothing related to the reports, page-wise).
First snag I ran into was that the Report server (and manager) could not
load the System.web.extensions dll, that was deployed with my project. Both
report services virtual directories are sub-directories to my application on
Win 2K3, so it was inheriting that part of the web.config. I put a <remove>
section in both reporting services web.configs to remove the HttpModule
section named 'ScriptModule', added in to use ASP.NET Ajax v 1.0.
After doing that, the report server virtual directory comes up, so I can
basically browse the server, see the models, and even run the reports that
already exist etc, but can't use the ReportManager web app. The report
manager says that the report server could not be contacted, and to make sure
it is on. In the logs, it shows that a 500-server error was received, and
obviously ends there.
Any advice anyone has on what the problem might be, I'd appreciate it.
Thanks for the help,
PeteHello Pete,
I understand that you have an application to install the reporting services
and you could not get the report manager work.
According to the error state that the report manager could not find the
report server, you may check the following things:
1. RSWebApplication.config file under the C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportManager folder. You may check the
following element:
<UI>
<ReportServerUrl>http://yourservername/your application virtual dic
name/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
2. rsreportserver.config file under the C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer
<UrlRoot>http://yourservername/your application virtual dic
name/reportserver</UrlRoot>
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for the quick response. I tried what you suggested below and it
still didn't fix the problem. Here's a bit more information about the setup.
The DB, Report Server, and IIS for the application all run on the same box,
which is running Windows Server 2K3. I have it setup that the Website is
called <appname> and then it has two virtual directories underneath that
website for ReportServer and ReportManager. Since it is an intranet
application, you access it by going to http://machinename, which defaults to
the one website on it. If you go to http://machinename/ReportManager, you
can access the GUI to manage reports, models, etc. (at least before it was
broken). Going to http://machinename/ReportServer gives you the website
browsing aspect of it, but not the GUI you'd expect.
In the config files you had me check for ReportManager, the <ReportServUrl>
field was empty, but the ReportServer virtual directory field was filled in,
with the proper name of the virtual directory. The <UrlRoot> you mentioned
was already filled in and point to the same URL mentioned above for the
ReportServer itself.
On another note, as I had only been using the ASP.NET AJAX extensions in one
location, I removed that UpdatePanel, and all ajax related items in my
application-specific web.config file, and the Report Manager worked again
immediately. So, I'm thinking there is some direct connection to the two
that I can't find out that is causing it to crash.
Again, any help would be very much appreciated. I don't really think just
avoiding the ASP.NET Ajax extensions is a viable option in the long term.
Thanks,
Pete|||Hello Pete,
I would like to know if you put the whole url for the report server in the
<ReportServUrl> and remove the virtual directory value,
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Yes, I put the full path of the reportServer URl into that location, and
removed the reference to the ReportServerVirtual directory. That
unfortunately did not fix the problem. Any other suggestions would be
appreciated.
Thanks,
Pete
"Wei Lu [MSFT]" wrote:
> Hello Pete,
> I would like to know if you put the whole url for the report server in the
> <ReportServUrl> and remove the virtual directory value,
>
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Pete,
Could you please let me get the report server error log?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Unfortunately I can't get you the client's server log - it is on a
restricted internal machine, and they don't allow internet access from it or
connection of external drives.
In order to provide for a temporary fix, I went ahead and un-did my ASP.NET
Ajax changes in the web.config file and it started working again. It is far
from an ideal solution, but I didn't have time to work through it any more.
If you have any other solutions I'd like to hear them, as I'd like to improve
the UI of our application using ajax at some point in the future.
Thanks,
Pete
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Pete,
If you have time to get the reportserver error log, you may send it to me.
By default, the log file is located at \Microsoft SQL Server\<SQL Server
Instance>\Reporting Services\LogFiles.
Otherwise, I may lack of information to troubleshoot the error.
Hope it helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
So here's what happened. I had successfully deployed an ASP.Net
application, had it running and using SQL 2K5 reporting services just fine.
I rolled out an update to the application, and included an UpdatePanel in a
few of the pages (nothing related to the reports, page-wise).
First snag I ran into was that the Report server (and manager) could not
load the System.web.extensions dll, that was deployed with my project. Both
report services virtual directories are sub-directories to my application on
Win 2K3, so it was inheriting that part of the web.config. I put a <remove>
section in both reporting services web.configs to remove the HttpModule
section named 'ScriptModule', added in to use ASP.NET Ajax v 1.0.
After doing that, the report server virtual directory comes up, so I can
basically browse the server, see the models, and even run the reports that
already exist etc, but can't use the ReportManager web app. The report
manager says that the report server could not be contacted, and to make sure
it is on. In the logs, it shows that a 500-server error was received, and
obviously ends there.
Any advice anyone has on what the problem might be, I'd appreciate it.
Thanks for the help,
PeteHello Pete,
I understand that you have an application to install the reporting services
and you could not get the report manager work.
According to the error state that the report manager could not find the
report server, you may check the following things:
1. RSWebApplication.config file under the C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportManager folder. You may check the
following element:
<UI>
<ReportServerUrl>http://yourservername/your application virtual dic
name/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
2. rsreportserver.config file under the C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer
<UrlRoot>http://yourservername/your application virtual dic
name/reportserver</UrlRoot>
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for the quick response. I tried what you suggested below and it
still didn't fix the problem. Here's a bit more information about the setup.
The DB, Report Server, and IIS for the application all run on the same box,
which is running Windows Server 2K3. I have it setup that the Website is
called <appname> and then it has two virtual directories underneath that
website for ReportServer and ReportManager. Since it is an intranet
application, you access it by going to http://machinename, which defaults to
the one website on it. If you go to http://machinename/ReportManager, you
can access the GUI to manage reports, models, etc. (at least before it was
broken). Going to http://machinename/ReportServer gives you the website
browsing aspect of it, but not the GUI you'd expect.
In the config files you had me check for ReportManager, the <ReportServUrl>
field was empty, but the ReportServer virtual directory field was filled in,
with the proper name of the virtual directory. The <UrlRoot> you mentioned
was already filled in and point to the same URL mentioned above for the
ReportServer itself.
On another note, as I had only been using the ASP.NET AJAX extensions in one
location, I removed that UpdatePanel, and all ajax related items in my
application-specific web.config file, and the Report Manager worked again
immediately. So, I'm thinking there is some direct connection to the two
that I can't find out that is causing it to crash.
Again, any help would be very much appreciated. I don't really think just
avoiding the ASP.NET Ajax extensions is a viable option in the long term.
Thanks,
Pete|||Hello Pete,
I would like to know if you put the whole url for the report server in the
<ReportServUrl> and remove the virtual directory value,
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Yes, I put the full path of the reportServer URl into that location, and
removed the reference to the ReportServerVirtual directory. That
unfortunately did not fix the problem. Any other suggestions would be
appreciated.
Thanks,
Pete
"Wei Lu [MSFT]" wrote:
> Hello Pete,
> I would like to know if you put the whole url for the report server in the
> <ReportServUrl> and remove the virtual directory value,
>
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Pete,
Could you please let me get the report server error log?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Unfortunately I can't get you the client's server log - it is on a
restricted internal machine, and they don't allow internet access from it or
connection of external drives.
In order to provide for a temporary fix, I went ahead and un-did my ASP.NET
Ajax changes in the web.config file and it started working again. It is far
from an ideal solution, but I didn't have time to work through it any more.
If you have any other solutions I'd like to hear them, as I'd like to improve
the UI of our application using ajax at some point in the future.
Thanks,
Pete
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Pete,
If you have time to get the reportserver error log, you may send it to me.
By default, the log file is located at \Microsoft SQL Server\<SQL Server
Instance>\Reporting Services\LogFiles.
Otherwise, I may lack of information to troubleshoot the error.
Hope it helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Monday, March 12, 2012
Report Manager over SSL
SQL Server 2005 and Reporting Services.
Has anyone successfully configured Report Manager and Report Server (Virtual
Directories) to operate over SSL?
If so, how? I have set all the settings I know of, but can't get it to go.
Thanks.do you have 1 server or 2 servers?
the SSL certificate come from your enterprise CA or external company like
verisign?
what is the error message?
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message
news:%235E%23%23yBKGHA.916@.TK2MSFTNGP10.phx.gbl...
> SQL Server 2005 and Reporting Services.
> Has anyone successfully configured Report Manager and Report Server
> (Virtual Directories) to operate over SSL?
> If so, how? I have set all the settings I know of, but can't get it to
> go.
> Thanks.
>|||I have 1 server. I do not have a CA, I am using a freeware SSL.
It's not that I am getting the errors, it's that when I am in report
manager, all my links are https: except for the Upload File, Report Builder,
New Folder, etc... are all http and won't work.
Any suggestions?
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:O1to4ECKGHA.532@.TK2MSFTNGP15.phx.gbl...
> do you have 1 server or 2 servers?
> the SSL certificate come from your enterprise CA or external company like
> verisign?
> what is the error message?
> "Kevin Antel" <kevina@.cqlcorp.com> wrote in message
> news:%235E%23%23yBKGHA.916@.TK2MSFTNGP10.phx.gbl...
>> SQL Server 2005 and Reporting Services.
>> Has anyone successfully configured Report Manager and Report Server
>> (Virtual Directories) to operate over SSL?
>> If so, how? I have set all the settings I know of, but can't get it to
>> go.
>> Thanks.
>|||The goal is to have a remote branch, over the Internet, use HTTPS to run the
report manager and build/upload reports for our customers.
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:O1to4ECKGHA.532@.TK2MSFTNGP15.phx.gbl...
> do you have 1 server or 2 servers?
> the SSL certificate come from your enterprise CA or external company like
> verisign?
> what is the error message?
> "Kevin Antel" <kevina@.cqlcorp.com> wrote in message
> news:%235E%23%23yBKGHA.916@.TK2MSFTNGP10.phx.gbl...
>> SQL Server 2005 and Reporting Services.
>> Has anyone successfully configured Report Manager and Report Server
>> (Virtual Directories) to operate over SSL?
>> If so, how? I have set all the settings I know of, but can't get it to
>> go.
>> Thanks.
>
Has anyone successfully configured Report Manager and Report Server (Virtual
Directories) to operate over SSL?
If so, how? I have set all the settings I know of, but can't get it to go.
Thanks.do you have 1 server or 2 servers?
the SSL certificate come from your enterprise CA or external company like
verisign?
what is the error message?
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message
news:%235E%23%23yBKGHA.916@.TK2MSFTNGP10.phx.gbl...
> SQL Server 2005 and Reporting Services.
> Has anyone successfully configured Report Manager and Report Server
> (Virtual Directories) to operate over SSL?
> If so, how? I have set all the settings I know of, but can't get it to
> go.
> Thanks.
>|||I have 1 server. I do not have a CA, I am using a freeware SSL.
It's not that I am getting the errors, it's that when I am in report
manager, all my links are https: except for the Upload File, Report Builder,
New Folder, etc... are all http and won't work.
Any suggestions?
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:O1to4ECKGHA.532@.TK2MSFTNGP15.phx.gbl...
> do you have 1 server or 2 servers?
> the SSL certificate come from your enterprise CA or external company like
> verisign?
> what is the error message?
> "Kevin Antel" <kevina@.cqlcorp.com> wrote in message
> news:%235E%23%23yBKGHA.916@.TK2MSFTNGP10.phx.gbl...
>> SQL Server 2005 and Reporting Services.
>> Has anyone successfully configured Report Manager and Report Server
>> (Virtual Directories) to operate over SSL?
>> If so, how? I have set all the settings I know of, but can't get it to
>> go.
>> Thanks.
>|||The goal is to have a remote branch, over the Internet, use HTTPS to run the
report manager and build/upload reports for our customers.
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:O1to4ECKGHA.532@.TK2MSFTNGP15.phx.gbl...
> do you have 1 server or 2 servers?
> the SSL certificate come from your enterprise CA or external company like
> verisign?
> what is the error message?
> "Kevin Antel" <kevina@.cqlcorp.com> wrote in message
> news:%235E%23%23yBKGHA.916@.TK2MSFTNGP10.phx.gbl...
>> SQL Server 2005 and Reporting Services.
>> Has anyone successfully configured Report Manager and Report Server
>> (Virtual Directories) to operate over SSL?
>> If so, how? I have set all the settings I know of, but can't get it to
>> go.
>> Thanks.
>
Report Manager error
Some weeks back I successfully installed SQL Server RS SP1 on a Win2K Server
(note it is NOT a domain controller). All worked fine.
Recently, following a restart of the machine, I get the following error:
Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\bin" is denied.
I have read numerous posts on this issue. Some suggest the documented
workaround IF the server is a DC. All other posts don't appear to have been
resolved.
I have granted full control to Everyone for the ReportManager and bin
folders but to no effect.
Has anyone encountered the fix for this issue?
Thanks.For anyone that might have stumbled on to this post... I found the solution -
eventually.
Check out the "Impersonate a client after authentication" local policy. The
local ASPNET account must be included. In my case a domain policy was
overriding the local policy.
(note it is NOT a domain controller). All worked fine.
Recently, following a restart of the machine, I get the following error:
Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\bin" is denied.
I have read numerous posts on this issue. Some suggest the documented
workaround IF the server is a DC. All other posts don't appear to have been
resolved.
I have granted full control to Everyone for the ReportManager and bin
folders but to no effect.
Has anyone encountered the fix for this issue?
Thanks.For anyone that might have stumbled on to this post... I found the solution -
eventually.
Check out the "Impersonate a client after authentication" local policy. The
local ASPNET account must be included. In my case a domain policy was
overriding the local policy.
Friday, March 9, 2012
Report Loading Error
I have developed a report and deployed it successfully. After I input all the parameters, the report cannot be displayed and shows the error as follows:
???? (rsProcessingAborted) ??
??? 'tempDB' ?? (rsErrorOpeningConnection) ??
Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection.
The report can be loaded a few times before and cannot be loaded now.
I have checked that the DB security setting of authentication is set to "SQL Server and Windows" already.
Any idea to solve this problem?
msfriend wrote:
I have developed a report and deployed it successfully. After I input all the parameters, the report cannot be displayed and shows the error as follows: ???? (rsProcessingAborted) ?? ??? 'tempDB' ?? (rsErrorOpeningConnection) ?? Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection. The report can be loaded a few times before and cannot be loaded now. I have checked that the DB security setting of authentication is set to "SQL Server and Windows" already. Any idea to solve this problem?
Should be authentication problem. Did you find any solution?
Subscribe to:
Posts (Atom)