Model Query Designer

I added the RS extension to RSReportServer.config. Then, I restarted
the report server. Now it works!Could you please explain how and where exactly in the config file you added
it?
Thanks,
Nancy
<fmatamoros@.yahoo.com> wrote in message
news:1179967924.559739.15150@.d30g2000prg.googlegroups.com...
>I added the RS extension to RSReportServer.config. Then, I restarted
> the report server. Now it works!
>sql

Model Designer - ODBC Data Source

I want to create a Model against an ODBC data source.

This is not possible in the June CTP.

Will this facility be available in a future release?

Thanks,
JoeI've raised this as a call with Microsoft through our Partner Program.

Will post the result here when I get an answer.|||As promised here is Microsoft's reply:

Please find the answers to your queries below:

Query:

=======

You want to be able to create an Ad-hoc Report Model using the Model Designer in Visual Studio 2005.

You want to be able to use an ODBC data source for this model - currently the only option is to use the “SQL Client Data Provider”.

So you need to know whether this will be addressed in the final release of SQL Server 2005 (or any CTPs of SQL Server 2005 before then).

Solution:

==========

As of now only SQL and Analysis Services are directly supported as a data source for Report Builder.

However you can connect to the ODBC data source using SQL or Analysis Services. We have the following two ways to get this working:

Option I:

-

UDM (Unified Dimensional Model) is essentially a way that SQL Analysis Services 2005 can combine multiple sources of data into one model. Let’s say your “Sales” information is one an Oracle data store, your “HR” info is in SQL, and your “Inventory” is in DB2 – You would build a UDM which includes all three of these data sources, and then you could report against the UDM as if ALL of the information lived inside Analysis Services.

So, by using a UDM to point to the ODBC data source, you enable Report Builder to get at the data too, since Report Builder CAN report against Analysis Services.

Option II:

--

You could try this but the performance expected is not very good with this option:

1. create linked servers in order to reference the ODBC (or other) data sources

2. create a layer of views in a SQL Server database accessing the other database through the linked server mechanism. You could use just simple views to expose the contents of the underlying tables with 'select *'. For example:
create view MyODBCTableView as select * from LinkedServerName..SchemaOwner.TableX

3. build SQL Server views on top of these views as desired

4. build the Report Model against these SQL Views

5. use Report Builder to query the OBDC data source through this 'proxy'

The following link is useful for more information and resources on SQL Server 2005:

http://www.microsoft.com/uk/partner/sol_and_products/servers/sql/

|||Unfortunately the chaps from Partner Tech Support were misinformed.

This is a reply from MSAS newsgroup :

AS2005 is not going to support ODBC data source. However, you can try to
create a data source in SSIS project. Then, add the data source into new AS
project. You should be able to create DSV, cube and dimension, etc.

However, since this feature is not supported. Believe that this area has not
been tested enough and this may break engine or not working probably. It is
"AS IS" if you really want to use it.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Ken Kwok
SQL Server Analysis Services

Missing Value property of calculated member

Hi,

I defined several calculated measures in my cube. In Report Designer, i want to filter data depending a calculated measure.

Some caluclated measures are missing properties like value or ismissing. Anybody a hint, why these measures dont provide the properties, as for that filtering or hiding is not possible.

In AS every property is the sam for all calcs and the leaking calcs dont have difficult expressions (IIF(measure<0,measure/measure,0.0)

Thanks in advance

Please provide steps to repro this against the AdventureWorks sample cube.|||

Value property is working, even when it gets red underlined in visual studio.

So it works for me now.

Missing Value property of calculated member

Hi,

I defined several calculated measures in my cube. In Report Designer, i want to filter data depending a calculated measure.

Some caluclated measures are missing properties like value or ismissing. Anybody a hint, why these measures dont provide the properties, as for that filtering or hiding is not possible.

In AS every property is the sam for all calcs and the leaking calcs dont have difficult expressions (IIF(measure<0,measure/measure,0.0)

Thanks in advance

Please provide steps to repro this against the AdventureWorks sample cube.|||

Value property is working, even when it gets red underlined in visual studio.

So it works for me now.

Missing Images in rendered HTML View

Hi,

i have a report with an image on the footer. When i view the report in the designer/report manager or export to any format, everythings fine. Now i have a ASP.NET site which makes a webservice call to get HTML output from my report. in this case no image show up. The Url of the image is like that: h**p://servername/ReportServer?%2fDocuments%2fGerman%2fOrder%2fOrderResponse&rs%3aFormat=HTML4.0&rs%3aImageID=ac8c4a8c-8a63-4ff9-ba74-6d6a7076a0ef

When i check the HTML version of the Report Manager the url of the image is like: h**p://servername/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=iuwsgfikvz4ezfmd0tqmyj45&ControlID=cee4d933-5ab6-413f-8c28-4c3a2b3ff230&Culture=1031&UICulture=7&ReportStack=1&OpType=ReportImage&StreamID=84e7491d-eab4-4502-adac-2bec4254da90

I take the byte stream of the report from the RS Service an put it to the HttpResponse of the ASP.NET page.

What could be the problem?

When you render a report which contains an image or a chart (which is really just an image), you not only have to call Render(), but then you call RenderStream() for each image in the report. Books online has some good examples of this.|||

Ok, when i understand it correctly, the RenderStream method provides the functionality to get each image stream for this report.

The images in my report are external images and are part of the project. In this case i can use the DeviceInfo - parameter HTMLFragment set to true. But this doesn't work.

What could be te problem?