Calculated Measures not showing in SSRS.

Hi,
I have two cubes , One is fairly large Cube and the other one is Smaller one.
When I try to Use SSRS to report on these two cubes, i could see the calculated measures only in the Smaller Cube and there are no such things in the Large Cube.
I could Report on the Large Cube with base Measures.
I see the below message at the end of the Measures List.
"More Measures Exists than can Be shown."

Am i missing something?
Can anyone point me to some clue .

Thankyou
Vidya

Hi,

did you reprocess the large cube after,adding the calculated measures?

|||

I have not used SSRS yet, but I came accross a similar issue when I was creating a cube.

When you create a cube on SSAS, it automatically creates a script called "CALCULATE." You can view it on Caluculation tab on the cube design. It contains the following code:

/*

The CALCULATE command controls the aggregation of leaf cells in the cube.

If the CALCULATE command is deleted or modified, the data within the cube is affected.

You should edit this command only if you manually specify how the cube is aggregated.

*/

CALCULATE

If this script is modified or deleted, you may not see your measures correctly in your cube.

|||Thankyou for the Reply,
But I Have that CALCULATE untouched.
Another intresting note is that i can see all the calculated measures with the values from EXCEL 2007.
When i try querying the cube for the Calculated Measure then i am getting the values ; Only problem is that i am not able to see them through SSRS.
I have tried re-processing the Cube but no luck.
Thankyou
vidya

Bypass HTML rendering in SSRS 2000

Hi all,
I have a report (in SQL Server 2000) in a web page that is very slow when it
renders the data.
The query is not so slow to justify this problem (running it in Query
Analyzer it takes only a few seconds).
Does not have image or text field, just varchar.
I think, it's possible to "bypass" HTML rendering to reach at once Excel
rendering?
Actually the purpose of the page is to obtain a report in Excel.
Thanks a lot.
--
LuigiHTML and CSV are the fastest formats for rendering. PDF and Excel are much
slower. With RS 2000 they are an order of magnitude slower. RS 2005 sped up
significantly. RS 2008 promises additional speed improvements.
If you are using your own webpage then request the render in Excel. This is
possible with either web services or URL integration. Otherwise, if you are
using Report Manager then I suggest having a report with the parameters and
then a single textbox. The textbox just says export to Excel. Underline and
make it blue. Right mouse click, properties, Navigation, Jump to URL. The
below in Jump To URL opens up in Excel:
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=Excel','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=Excel"
Note if the data is big you are better off to use CSV ASCII format. Excel
still automatically comes up with the data.
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Luigi" <ciupazNoSpamGrazie@.inwind.it> wrote in message
news:27F7106D-8198-4D9F-B0F7-991EDB78BF71@.microsoft.com...
> Hi all,
> I have a report (in SQL Server 2000) in a web page that is very slow when
> it
> renders the data.
> The query is not so slow to justify this problem (running it in Query
> Analyzer it takes only a few seconds).
> Does not have image or text field, just varchar.
> I think, it's possible to "bypass" HTML rendering to reach at once Excel
> rendering?
> Actually the purpose of the page is to obtain a report in Excel.
> Thanks a lot.
> --
> Luigi
>|||"Bruce L-C [MVP]" wrote:
> HTML and CSV are the fastest formats for rendering. PDF and Excel are much
> slower. With RS 2000 they are an order of magnitude slower. RS 2005 sped up
> significantly. RS 2008 promises additional speed improvements.
> If you are using your own webpage then request the render in Excel. This is
> possible with either web services or URL integration. Otherwise, if you are
> using Report Manager then I suggest having a report with the parameters and
> then a single textbox. The textbox just says export to Excel. Underline and
> make it blue. Right mouse click, properties, Navigation, Jump to URL. The
> below in Jump To URL opens up in Excel:
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=Excel','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=Excel"
> Note if the data is big you are better off to use CSV ASCII format. Excel
> still automatically comes up with the data.
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>
Thank you so much Bruce, I'll test your suggestions asap.
I noticed that exporting in CSV format is a bit faster, and could be a
possible solution.
But when I obtain the CSV report, fields are separated by a comma (,), and
when I try to open this .csv in Excel, all fileds get into the first cell.
I think this is a problem due to italian settings (in english Excel this
problem does not pop up).
To solve this issues I have to replace commas with semicolons, but is a
dirty solution.
Luigi|||Hi Bruce,
I'm trying to do this:
=Globals!ReportServerUrl & "?/Report1" & "&rs:Format=Excel"
or
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?C:\projects\SNV\Software Components\Code\Bnpparibas.Sit.Reports\Report1" &
"&rs:Format=Excel','_blank'))"
but none working (no effect clicking on the hyperlink).
The report has no parameters.
What is it wrong?
Thanks.
Luigi|||A few things:
- I assume you put this in Jump to URL.
- You have to include the folder on the server the report resides
- You cannot test this from development. You have to deploy it. Jump to
report can be tested in development but not jump to URL
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Luigi" <ciupazNoSpamGrazie@.inwind.it> wrote in message
news:896D6262-E100-448A-9706-85CA10E634C0@.microsoft.com...
> Hi Bruce,
> I'm trying to do this:
> =Globals!ReportServerUrl & "?/Report1" & "&rs:Format=Excel"
> or
>
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?C:\projects\SNV\Software Components\Code\Bnpparibas.Sit.Reports\Report1"
> &
> "&rs:Format=Excel','_blank'))"
> but none working (no effect clicking on the hyperlink).
> The report has no parameters.
> What is it wrong?
> Thanks.
> Luigi|||"Bruce L-C [MVP]" wrote:
> A few things:
> - I assume you put this in Jump to URL.
> - You have to include the folder on the server the report resides
> - You cannot test this from development. You have to deploy it. Jump to
> report can be tested in development but not jump to URL
Hi Bruce,
yes, you're right.
My tests were on Visual Studio environment, and now I'm trying to test the
report on development environment.
I'll tell you.
Luigi

Buttons

Hi.

Is there a way to insert a command button or flash button on to a report?

im using SSRS 2005 with VS 2005

Thanks...

You can't put standard controls on a report just specific RS controls.

You could put an image of a button and have some click through action on it.

|||But what about the effects of a button? Are there any rollover or click events?|||I can't think of a way.

Business Scorecard Manager

hello -
We are looking for a 3rd party tool for dashboarding, gauges and Key
Performance Indicators (KPIs).
We are already using SSRS 2005 for reporting purposes.
Is MS's Business Scorecard Manager
(http://office.microsoft.com/en-us/FX012225041033.aspx) anyway related
to SSRS 2005?
Is Business Scorecard Manager another BI module in SQL Server 2005?
any inputs are appreciated.
thanks
- jasthiWe just had a demo for Business Scorecard Manager. It is a separate
application that runs on Sharepoint (Services or Portal). It can pull data
from any datasource directly or through cubes from multiple datasources. It
can incorporate reports from Reporting Services (2000 or 2005).
I'm totally new at Scorecard Manager, but this is my understanding so far.
So anyone can correct me or add more...
"siva.jasthi@.gmail.com" wrote:
> hello -
> We are looking for a 3rd party tool for dashboarding, gauges and Key
> Performance Indicators (KPIs).
> We are already using SSRS 2005 for reporting purposes.
> Is MS's Business Scorecard Manager
> (http://office.microsoft.com/en-us/FX012225041033.aspx) anyway related
> to SSRS 2005?
> Is Business Scorecard Manager another BI module in SQL Server 2005?
> any inputs are appreciated.
> thanks
> - jasthi
>