Calculated Measure: Formula limitations

Hi,

I am using AMO to programmaticaly create the SSAS objects like Cubes, MeasureGroups, Measures, Calculated Measure, partitions .etc.

I pick the necessary information from an existing Oracle OLAP/datawarehouse. In the Oracle OLAP the calculated measure can contain any formulae which the oracle db can support. This means its a huge list....! for example, Log, Decode functions.

Though SQL Db provides these functions, they are not avaliable to use directly in the MDXScript of the Calculated Measure.

so now when I am synchronizing the Oracle OLAP to SSAS programmatically at runtime, how do I resolve these inconsistencies in the formulae?

Regards

Vijay R

I think you mixing several concepts.

You can still referece Oracle functions while in DSV. You can create Named query or Named caclulation referencing any feature avaliable in your relational database.

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

|||

Hi Edward,

I guess I did not explain it correctly, I will try and explain it again.

I have a Oracle OLAP with an J2EE web app. I can create measures, calculated measures and the likes. when i create calculated measures in the Oracle OLAP using the J2EE UI, I can provide any formulae which the Oracle core can understand.

so now for eg: I have defined 2 measures M1 and M2 in Oracle OLAP. Next I define a calculated measure in Oracle OLAP, Here I define a formula like (M1 + M2)/100. Now when i view the data I get three columns M1, M2 and Calculated Values (M1+M2)/100.

Now I have a AMO program in .NET that automatically picks up the new measures and their related table info from the Oracle Relational tables and creates the same ones in SSAS. This means it creates a cube, then creates a measure group, sets the source of the measure group to the Oracle relational table (fact table), then creates the measures and partitions. The source property for all these is still the oracle relational database. but the information as to which tables, columns to use is picked from the existing oracle OLAP.

finally I process the cube in SSAS, and it is browseable.

The problem is when i try to create the calculated measure that is there in Oracle OLAP. I retrive the formula of the measure as (M1 + M2)/100. Now what I do in AMO is add a MDX script that creates a Member and adds this formula to it. Now this becomes a calculated measure in SSAS. whose value is got on the leaf cells using the "CALCULATE" command in the MDX script.

This works fine for all operators like + , - , * , / and also for Avg, Sum. but when it gets a formula like decode .... or abs, the formula in the MDX script is not recognised by SSAS. This is because MSXScript does not have those functions. I cannot map them to any Oracle functions because they are all built in Oracle funtions. like you know 'decode' is a common Database function avaliable in SQL also.

I am still stuck with this. currently we are not syncronizing the measures which have such functions. I have written a filter for them :-). so how do we do this. I was thinking that we write a SQL CLR function and pass the formula to it, which converts the formula to a MDX normalized form or something. still not sure.

Okay, I forgot. I have not used names queries or named calcualtions. I thought that names queries are for a partition. I have a fixed SSAS datasource which is mapped to the oracle db. when i use AMO to create the partition i just specify the table name in the SSAS datasource. About named calculations, I have to frankly accept I have no idea about it. ( I will look at this)

today there was another problem while using aggregation functions like avg and sum in the calculated measures (see my new post ). Not sure what is happening.

Thanks for the reply.

Regards

|||

Several things.

One, please take a look at the named calculations. This allows you to create a new column in your DSV "pusihng" calculations to relational database.

Second, take a look at the Analysis Services stored procedures. See if you can write a stored procedure implementing the functionality you need. Later you will use stored procedure in your MDX query.

Hope that helps.

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

Caching Application Block and SQL 2005 SQL Dependency

I am building a web app using VS2005 and SQL 2005 I would like to use the Caching Application Block to cache objects from my BLL. I was wondering if there is a way of utilizing the build in SQLDependency in SQL 2005 with the Caching Application Block? Does anybody have tried this, are there any samples on the web?

Thanks,

Newbie

You can take a look at

http://msdn2.microsoft.com/en-us/library/a52dhwx7.aspx

http://msdn2.microsoft.com/en-us/library/t9x04ed2.aspx

Bypassing Ownership

I seriously need to revoke some of the persmissions my fellow developers misuse, I want them to be able to create objects manipulate them and the data but I dont want them to create databases and dont want them to have system administrator permissions.

when I change their login permissions all the objects they create appear with their user prefix for example programmer.Newobject, this sucks, I dont want our objects to have tons of programmer names in them making the code unreadable and unmanageable not to mention dependencies management.

is there some simple way to bypass ownership, or make all objects appear with the dbo prefix (which is the default, so you dont need to specify it) whats the point in this ownership thing, as if I dont have enough to worry about without making life harder for myself. oh, and as I said I dont want them to use the SA login or have SA permissions.

thanks people.remove user programmer and fire:

exec sp_addalias 'programmer','dbo'

Business Objects vs. Analysis Services and IT Bullies

Hello,

I've been working on implementing an SSAS solution for my department. The Proof of Concept is working very well and I am ready to implement it. However, some bullies from IT have come in and said that cubes are not the correct way to go about this (even though it is working) and that we need to call Business Objects and have them come in and tell us what they can provide.

To create my solution, I am using SSIS, SSRS, and SSAS. It is a great package that has everything in it and, frankly, I don't want to have to redo all my work.

When Business Solutions comes in I want to be able to ask them questions (objectively and fairly) about what they can provide us. If they have a better solution, then I should take it, but if it is sort of borderline, I want to be able to "win" with Microsoft and SQL Server 2005. One quick example that I know of is that when sending a report from Business Objects to Excel, the format is not always pretty and/or easy to deal with.

Any suggestions about a comparison list or feature by feature list of the two? Or maybe just some pointed questions about can Business Objects do X? Maybe questions about speed, stability, "plays well with others (Oracle)", etc.

Thank you for the help.

-Gumbatman

Hello! Here is my list:

Does BO have their own relational database and ETL tool?

Why should you pay for BO when you have SSAS, SSRS, SSIS, SQL Server 2005 bundled and without extra license cost?|||

Hi,

I implemeted a DW project last year, using SSIS then both Business Objects and SSAS on top of that. Have to say that the amount of time spent developing the BO universe and reports took almost as long as the ETL process (generally reporting times are far shorter).

From a support and development aspect, the extra level of design which is built into BO is a nightmare to support. You will end up needing people who are experts in both SQL and BO, not many, and those are all probably contracting.

Did notice that if your reports get complicated or the BO Universe does magical things, the performance hit was on the SQL Database. If the database is a transactional one rather than a DW you could encounter problems with performance. I don't think it has quite the same query performance as SSAS, although BO could do some very clever things that SSAS couldn't or would be very difficult to do (more in business modelling).

It also depends how many people are using the reports, more users probably more hits on the underlying database; I don't think there is any caching like in SSAS, so if someone runs the same report it will have to query the database again rather than hit the cache.

Don't think there are aggregations in BO, we didn't use any. Think we create table functions to aggregate things up to differnt levels of granularity.

In my opinion if you have a BO team in the company, it is a route you could use as well as SSAS. Allows you to migrate away from BO into a SSAS world..

The improvements of Excel 2007, reporting services in 2008 and proclarity all make BO look basic and dated.

Sure if you contact Microsoft and asked them the question, they would list a load of things. Probably have a fact file on the matter.

Sorry for the long reply!

Hope that helps

Matt

|||

Matt and Thomas,

Thank you for the answers. This is great information and will go a long way for me.

-Gumbatman

Business Objects vs. Analysis Services and IT Bullies

Hello,

I've been working on implementing an SSAS solution for my department. The Proof of Concept is working very well and I am ready to implement it. However, some bullies from IT have come in and said that cubes are not the correct way to go about this (even though it is working) and that we need to call Business Objects and have them come in and tell us what they can provide.

To create my solution, I am using SSIS, SSRS, and SSAS. It is a great package that has everything in it and, frankly, I don't want to have to redo all my work.

When Business Solutions comes in I want to be able to ask them questions (objectively and fairly) about what they can provide us. If they have a better solution, then I should take it, but if it is sort of borderline, I want to be able to "win" with Microsoft and SQL Server 2005. One quick example that I know of is that when sending a report from Business Objects to Excel, the format is not always pretty and/or easy to deal with.

Any suggestions about a comparison list or feature by feature list of the two? Or maybe just some pointed questions about can Business Objects do X? Maybe questions about speed, stability, "plays well with others (Oracle)", etc.

Thank you for the help.

-Gumbatman

Hello! Here is my list:

Does BO have their own relational database and ETL tool?

Why should you pay for BO when you have SSAS, SSRS, SSIS, SQL Server 2005 bundled and without extra license cost?|||

Hi,

I implemeted a DW project last year, using SSIS then both Business Objects and SSAS on top of that. Have to say that the amount of time spent developing the BO universe and reports took almost as long as the ETL process (generally reporting times are far shorter).

From a support and development aspect, the extra level of design which is built into BO is a nightmare to support. You will end up needing people who are experts in both SQL and BO, not many, and those are all probably contracting.

Did notice that if your reports get complicated or the BO Universe does magical things, the performance hit was on the SQL Database. If the database is a transactional one rather than a DW you could encounter problems with performance. I don't think it has quite the same query performance as SSAS, although BO could do some very clever things that SSAS couldn't or would be very difficult to do (more in business modelling).

It also depends how many people are using the reports, more users probably more hits on the underlying database; I don't think there is any caching like in SSAS, so if someone runs the same report it will have to query the database again rather than hit the cache.

Don't think there are aggregations in BO, we didn't use any. Think we create table functions to aggregate things up to differnt levels of granularity.

In my opinion if you have a BO team in the company, it is a route you could use as well as SSAS. Allows you to migrate away from BO into a SSAS world..

The improvements of Excel 2007, reporting services in 2008 and proclarity all make BO look basic and dated.

Sure if you contact Microsoft and asked them the question, they would list a load of things. Probably have a fact file on the matter.

Sorry for the long reply!

Hope that helps

Matt

|||

Matt and Thomas,

Thank you for the answers. This is great information and will go a long way for me.

-Gumbatman

Business Objects as datasource

Hi!
I've read somewhere that it is possible to use business objects as a data
source for the reporting services.
Can someone tell me where I can find further information about it?
Thanks
Klaus Aschenbrenner
MVP Visual C#
www.csharp.at, www.anecon.com
http://weblogs.asp.net/klaus.aschenbrennerWhere do you have seen that?
It's marvelous if it's possible...
Nicolas
"Klaus Aschenbrenner" wrote:
> Hi!
> I've read somewhere that it is possible to use business objects as a data
> source for the reporting services.
> Can someone tell me where I can find further information about it?
> Thanks
> Klaus Aschenbrenner
> MVP Visual C#
> www.csharp.at, www.anecon.com
> http://weblogs.asp.net/klaus.aschenbrenner
>
>|||I am not sure of the datasources of the previous versions of BusinessObjects
but the current version BO XI uses a MySQL backend but you can use MSDE or
SQL Server if you so choose. So as long as you can connect to the server with
a valid login you shouldn't have any problems reporting off of it just like
any other SQL Server database.
"Nicolas BRESSAN" wrote:
> Where do you have seen that?
> It's marvelous if it's possible...
> Nicolas
> "Klaus Aschenbrenner" wrote:
> > Hi!
> >
> > I've read somewhere that it is possible to use business objects as a data
> > source for the reporting services.
> > Can someone tell me where I can find further information about it?
> >
> > Thanks
> >
> > Klaus Aschenbrenner
> > MVP Visual C#
> > www.csharp.at, www.anecon.com
> > http://weblogs.asp.net/klaus.aschenbrenner
> >
> >
> >|||I think he means business objects not Business Objects (i.e. his own
business objects not the company).
Assuming I have the right interpretation you can create your own data
extension that would allow you to do this but it is not trivial. With VS
2005 and RS 2005 there will be two new controls: a webform and a winform
control. They have a local mode where you had it a dataset and a report and
away it goes. Since you can create a dataset in dotnet out of business
objects this should work for you. Note that local mode does have some
limitations (for instance no subscriptions).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Carl" <Carl@.discussions.microsoft.com> wrote in message
news:F32A8134-66D3-438B-97B6-0E066051EF8C@.microsoft.com...
>I am not sure of the datasources of the previous versions of
>BusinessObjects
> but the current version BO XI uses a MySQL backend but you can use MSDE or
> SQL Server if you so choose. So as long as you can connect to the server
> with
> a valid login you shouldn't have any problems reporting off of it just
> like
> any other SQL Server database.
>
> "Nicolas BRESSAN" wrote:
>> Where do you have seen that?
>> It's marvelous if it's possible...
>> Nicolas
>> "Klaus Aschenbrenner" wrote:
>> > Hi!
>> >
>> > I've read somewhere that it is possible to use business objects as a
>> > data
>> > source for the reporting services.
>> > Can someone tell me where I can find further information about it?
>> >
>> > Thanks
>> >
>> > Klaus Aschenbrenner
>> > MVP Visual C#
>> > www.csharp.at, www.anecon.com
>> > http://weblogs.asp.net/klaus.aschenbrenner
>> >
>> >
>> >|||I am also interested in finding out how to report off of my own business
objects in RS2005. Is there a simple way, without going through web services
or dataset, to use my business objects as datasource? Even a simpler
experiment: how do I use a collection of simple objects (strings, for
instance) as my datasource in RS2005? DataDynamic's ActiveReports allows you
to pass a collection to a report as its datasoure without any extra work,
such as going through a web service or transforming the collection to a
dataset, etc.;
Thanks in advance.
Pierre
"Bruce L-C [MVP]" wrote:
> I think he means business objects not Business Objects (i.e. his own
> business objects not the company).
> Assuming I have the right interpretation you can create your own data
> extension that would allow you to do this but it is not trivial. With VS
> 2005 and RS 2005 there will be two new controls: a webform and a winform
> control. They have a local mode where you had it a dataset and a report and
> away it goes. Since you can create a dataset in dotnet out of business
> objects this should work for you. Note that local mode does have some
> limitations (for instance no subscriptions).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Carl" <Carl@.discussions.microsoft.com> wrote in message
> news:F32A8134-66D3-438B-97B6-0E066051EF8C@.microsoft.com...
> >I am not sure of the datasources of the previous versions of
> >BusinessObjects
> > but the current version BO XI uses a MySQL backend but you can use MSDE or
> > SQL Server if you so choose. So as long as you can connect to the server
> > with
> > a valid login you shouldn't have any problems reporting off of it just
> > like
> > any other SQL Server database.
> >
> >
> >
> > "Nicolas BRESSAN" wrote:
> >
> >> Where do you have seen that?
> >>
> >> It's marvelous if it's possible...
> >>
> >> Nicolas
> >>
> >> "Klaus Aschenbrenner" wrote:
> >>
> >> > Hi!
> >> >
> >> > I've read somewhere that it is possible to use business objects as a
> >> > data
> >> > source for the reporting services.
> >> > Can someone tell me where I can find further information about it?
> >> >
> >> > Thanks
> >> >
> >> > Klaus Aschenbrenner
> >> > MVP Visual C#
> >> > www.csharp.at, www.anecon.com
> >> > http://weblogs.asp.net/klaus.aschenbrenner
> >> >
> >> >
> >> >
>
>|||I have used the local mode passing it a table (not a dataset, it wants a
table). Reading the help there is the ability to use your own business
objects. Personally, filling a table is pretty easy and isn't a bad way to
go.
Server mode you can do web service or create a data processing extension. I
am not aware of any other way in server mode to do this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"pcho" <pcho@.discussions.microsoft.com> wrote in message
news:6D08FD6E-2055-4096-9123-14207F7CA7FE@.microsoft.com...
>I am also interested in finding out how to report off of my own business
> objects in RS2005. Is there a simple way, without going through web
> services
> or dataset, to use my business objects as datasource? Even a simpler
> experiment: how do I use a collection of simple objects (strings, for
> instance) as my datasource in RS2005? DataDynamic's ActiveReports allows
> you
> to pass a collection to a report as its datasoure without any extra work,
> such as going through a web service or transforming the collection to a
> dataset, etc.;
> Thanks in advance.
> Pierre
>
> "Bruce L-C [MVP]" wrote:
>> I think he means business objects not Business Objects (i.e. his own
>> business objects not the company).
>> Assuming I have the right interpretation you can create your own data
>> extension that would allow you to do this but it is not trivial. With VS
>> 2005 and RS 2005 there will be two new controls: a webform and a winform
>> control. They have a local mode where you had it a dataset and a report
>> and
>> away it goes. Since you can create a dataset in dotnet out of business
>> objects this should work for you. Note that local mode does have some
>> limitations (for instance no subscriptions).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Carl" <Carl@.discussions.microsoft.com> wrote in message
>> news:F32A8134-66D3-438B-97B6-0E066051EF8C@.microsoft.com...
>> >I am not sure of the datasources of the previous versions of
>> >BusinessObjects
>> > but the current version BO XI uses a MySQL backend but you can use MSDE
>> > or
>> > SQL Server if you so choose. So as long as you can connect to the
>> > server
>> > with
>> > a valid login you shouldn't have any problems reporting off of it just
>> > like
>> > any other SQL Server database.
>> >
>> >
>> >
>> > "Nicolas BRESSAN" wrote:
>> >
>> >> Where do you have seen that?
>> >>
>> >> It's marvelous if it's possible...
>> >>
>> >> Nicolas
>> >>
>> >> "Klaus Aschenbrenner" wrote:
>> >>
>> >> > Hi!
>> >> >
>> >> > I've read somewhere that it is possible to use business objects as a
>> >> > data
>> >> > source for the reporting services.
>> >> > Can someone tell me where I can find further information about it?
>> >> >
>> >> > Thanks
>> >> >
>> >> > Klaus Aschenbrenner
>> >> > MVP Visual C#
>> >> > www.csharp.at, www.anecon.com
>> >> > http://weblogs.asp.net/klaus.aschenbrenner
>> >> >
>> >> >
>> >> >
>>|||Thank you very much for your answers Bruce. Could you please point me to the
direction where I can find more information on local mode v.s. server mode?
Thanks again!
Pierre
"Bruce L-C [MVP]" wrote:
> I have used the local mode passing it a table (not a dataset, it wants a
> table). Reading the help there is the ability to use your own business
> objects. Personally, filling a table is pretty easy and isn't a bad way to
> go.
> Server mode you can do web service or create a data processing extension. I
> am not aware of any other way in server mode to do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "pcho" <pcho@.discussions.microsoft.com> wrote in message
> news:6D08FD6E-2055-4096-9123-14207F7CA7FE@.microsoft.com...
> >I am also interested in finding out how to report off of my own business
> > objects in RS2005. Is there a simple way, without going through web
> > services
> > or dataset, to use my business objects as datasource? Even a simpler
> > experiment: how do I use a collection of simple objects (strings, for
> > instance) as my datasource in RS2005? DataDynamic's ActiveReports allows
> > you
> > to pass a collection to a report as its datasoure without any extra work,
> > such as going through a web service or transforming the collection to a
> > dataset, etc.;
> >
> > Thanks in advance.
> >
> > Pierre
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> I think he means business objects not Business Objects (i.e. his own
> >> business objects not the company).
> >>
> >> Assuming I have the right interpretation you can create your own data
> >> extension that would allow you to do this but it is not trivial. With VS
> >> 2005 and RS 2005 there will be two new controls: a webform and a winform
> >> control. They have a local mode where you had it a dataset and a report
> >> and
> >> away it goes. Since you can create a dataset in dotnet out of business
> >> objects this should work for you. Note that local mode does have some
> >> limitations (for instance no subscriptions).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Carl" <Carl@.discussions.microsoft.com> wrote in message
> >> news:F32A8134-66D3-438B-97B6-0E066051EF8C@.microsoft.com...
> >> >I am not sure of the datasources of the previous versions of
> >> >BusinessObjects
> >> > but the current version BO XI uses a MySQL backend but you can use MSDE
> >> > or
> >> > SQL Server if you so choose. So as long as you can connect to the
> >> > server
> >> > with
> >> > a valid login you shouldn't have any problems reporting off of it just
> >> > like
> >> > any other SQL Server database.
> >> >
> >> >
> >> >
> >> > "Nicolas BRESSAN" wrote:
> >> >
> >> >> Where do you have seen that?
> >> >>
> >> >> It's marvelous if it's possible...
> >> >>
> >> >> Nicolas
> >> >>
> >> >> "Klaus Aschenbrenner" wrote:
> >> >>
> >> >> > Hi!
> >> >> >
> >> >> > I've read somewhere that it is possible to use business objects as a
> >> >> > data
> >> >> > source for the reporting services.
> >> >> > Can someone tell me where I can find further information about it?
> >> >> >
> >> >> > Thanks
> >> >> >
> >> >> > Klaus Aschenbrenner
> >> >> > MVP Visual C#
> >> >> > www.csharp.at, www.anecon.com
> >> >> > http://weblogs.asp.net/klaus.aschenbrenner
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
> >>
>
>|||This will get you started:
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.localreport.aspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"pcho" <pcho@.discussions.microsoft.com> wrote in message
news:7B54CB73-A909-483A-A340-29E2C1D8BEC8@.microsoft.com...
> Thank you very much for your answers Bruce. Could you please point me to
> the
> direction where I can find more information on local mode v.s. server
> mode?
> Thanks again!
> Pierre
>
> "Bruce L-C [MVP]" wrote:
>> I have used the local mode passing it a table (not a dataset, it wants a
>> table). Reading the help there is the ability to use your own business
>> objects. Personally, filling a table is pretty easy and isn't a bad way
>> to
>> go.
>> Server mode you can do web service or create a data processing extension.
>> I
>> am not aware of any other way in server mode to do this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "pcho" <pcho@.discussions.microsoft.com> wrote in message
>> news:6D08FD6E-2055-4096-9123-14207F7CA7FE@.microsoft.com...
>> >I am also interested in finding out how to report off of my own business
>> > objects in RS2005. Is there a simple way, without going through web
>> > services
>> > or dataset, to use my business objects as datasource? Even a simpler
>> > experiment: how do I use a collection of simple objects (strings, for
>> > instance) as my datasource in RS2005? DataDynamic's ActiveReports
>> > allows
>> > you
>> > to pass a collection to a report as its datasoure without any extra
>> > work,
>> > such as going through a web service or transforming the collection to a
>> > dataset, etc.;
>> >
>> > Thanks in advance.
>> >
>> > Pierre
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> I think he means business objects not Business Objects (i.e. his own
>> >> business objects not the company).
>> >>
>> >> Assuming I have the right interpretation you can create your own data
>> >> extension that would allow you to do this but it is not trivial. With
>> >> VS
>> >> 2005 and RS 2005 there will be two new controls: a webform and a
>> >> winform
>> >> control. They have a local mode where you had it a dataset and a
>> >> report
>> >> and
>> >> away it goes. Since you can create a dataset in dotnet out of business
>> >> objects this should work for you. Note that local mode does have some
>> >> limitations (for instance no subscriptions).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Carl" <Carl@.discussions.microsoft.com> wrote in message
>> >> news:F32A8134-66D3-438B-97B6-0E066051EF8C@.microsoft.com...
>> >> >I am not sure of the datasources of the previous versions of
>> >> >BusinessObjects
>> >> > but the current version BO XI uses a MySQL backend but you can use
>> >> > MSDE
>> >> > or
>> >> > SQL Server if you so choose. So as long as you can connect to the
>> >> > server
>> >> > with
>> >> > a valid login you shouldn't have any problems reporting off of it
>> >> > just
>> >> > like
>> >> > any other SQL Server database.
>> >> >
>> >> >
>> >> >
>> >> > "Nicolas BRESSAN" wrote:
>> >> >
>> >> >> Where do you have seen that?
>> >> >>
>> >> >> It's marvelous if it's possible...
>> >> >>
>> >> >> Nicolas
>> >> >>
>> >> >> "Klaus Aschenbrenner" wrote:
>> >> >>
>> >> >> > Hi!
>> >> >> >
>> >> >> > I've read somewhere that it is possible to use business objects
>> >> >> > as a
>> >> >> > data
>> >> >> > source for the reporting services.
>> >> >> > Can someone tell me where I can find further information about
>> >> >> > it?
>> >> >> >
>> >> >> > Thanks
>> >> >> >
>> >> >> > Klaus Aschenbrenner
>> >> >> > MVP Visual C#
>> >> >> > www.csharp.at, www.anecon.com
>> >> >> > http://weblogs.asp.net/klaus.aschenbrenner
>> >> >> >
>> >> >> >
>> >> >> >
>> >>
>> >>
>> >>
>>|||Hi Bruce, I have read something in Microsoft's marketing material and I was
wondering if you could clarify one point for me. The exact quotation is as
follows:
Visual Studio Integration
In addition to creating reports in a Report Server project, report design is
now completely integrated with Visual Studio language projects. You can embed
reports directly in any Windows Forms or ASP.NET Web application. The data
access options of embedded reports are a natural extension of the Visual
Studio data facilities. Not only can you use traditional databases as a
source of data for your reports, you can use object collections as well.
Report Designer, as shown in a language project, is highlighted in Figure 9.
The URL of the above quotation is:
http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx
In the second last sentence: "Not only can you use traditional databases as
a source of data for your reports, you can use object collections as well.",
what is meant by "object collections" here?
Again, my objective is to report right from a collection of objects (simple
or complex), no datasets, no web services, no XML, how do I do it?
Thank you very much again in advance!
Pierre
"Bruce L-C [MVP]" wrote:
> This will get you started:
> http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.localreport.aspx
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "pcho" <pcho@.discussions.microsoft.com> wrote in message
> news:7B54CB73-A909-483A-A340-29E2C1D8BEC8@.microsoft.com...
> > Thank you very much for your answers Bruce. Could you please point me to
> > the
> > direction where I can find more information on local mode v.s. server
> > mode?
> >
> > Thanks again!
> >
> > Pierre
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> I have used the local mode passing it a table (not a dataset, it wants a
> >> table). Reading the help there is the ability to use your own business
> >> objects. Personally, filling a table is pretty easy and isn't a bad way
> >> to
> >> go.
> >>
> >> Server mode you can do web service or create a data processing extension.
> >> I
> >> am not aware of any other way in server mode to do this.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "pcho" <pcho@.discussions.microsoft.com> wrote in message
> >> news:6D08FD6E-2055-4096-9123-14207F7CA7FE@.microsoft.com...
> >> >I am also interested in finding out how to report off of my own business
> >> > objects in RS2005. Is there a simple way, without going through web
> >> > services
> >> > or dataset, to use my business objects as datasource? Even a simpler
> >> > experiment: how do I use a collection of simple objects (strings, for
> >> > instance) as my datasource in RS2005? DataDynamic's ActiveReports
> >> > allows
> >> > you
> >> > to pass a collection to a report as its datasoure without any extra
> >> > work,
> >> > such as going through a web service or transforming the collection to a
> >> > dataset, etc.;
> >> >
> >> > Thanks in advance.
> >> >
> >> > Pierre
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> I think he means business objects not Business Objects (i.e. his own
> >> >> business objects not the company).
> >> >>
> >> >> Assuming I have the right interpretation you can create your own data
> >> >> extension that would allow you to do this but it is not trivial. With
> >> >> VS
> >> >> 2005 and RS 2005 there will be two new controls: a webform and a
> >> >> winform
> >> >> control. They have a local mode where you had it a dataset and a
> >> >> report
> >> >> and
> >> >> away it goes. Since you can create a dataset in dotnet out of business
> >> >> objects this should work for you. Note that local mode does have some
> >> >> limitations (for instance no subscriptions).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Carl" <Carl@.discussions.microsoft.com> wrote in message
> >> >> news:F32A8134-66D3-438B-97B6-0E066051EF8C@.microsoft.com...
> >> >> >I am not sure of the datasources of the previous versions of
> >> >> >BusinessObjects
> >> >> > but the current version BO XI uses a MySQL backend but you can use
> >> >> > MSDE
> >> >> > or
> >> >> > SQL Server if you so choose. So as long as you can connect to the
> >> >> > server
> >> >> > with
> >> >> > a valid login you shouldn't have any problems reporting off of it
> >> >> > just
> >> >> > like
> >> >> > any other SQL Server database.
> >> >> >
> >> >> >
> >> >> >
> >> >> > "Nicolas BRESSAN" wrote:
> >> >> >
> >> >> >> Where do you have seen that?
> >> >> >>
> >> >> >> It's marvelous if it's possible...
> >> >> >>
> >> >> >> Nicolas
> >> >> >>
> >> >> >> "Klaus Aschenbrenner" wrote:
> >> >> >>
> >> >> >> > Hi!
> >> >> >> >
> >> >> >> > I've read somewhere that it is possible to use business objects
> >> >> >> > as a
> >> >> >> > data
> >> >> >> > source for the reporting services.
> >> >> >> > Can someone tell me where I can find further information about
> >> >> >> > it?
> >> >> >> >
> >> >> >> > Thanks
> >> >> >> >
> >> >> >> > Klaus Aschenbrenner
> >> >> >> > MVP Visual C#
> >> >> >> > www.csharp.at, www.anecon.com
> >> >> >> > http://weblogs.asp.net/klaus.aschenbrenner
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||From MSDN Library (you should also be able to search this on the msdn
website). I searched on Localreport business objects:
The LocalReport object does not have the ability to execute queries or fetch
data; instead data must be supplied to it as instances of ADO.NET DataTables
or as a collection of business objects.
Also found this: Walkthrough: Using a Business Object Data Source with the
ReportViewer Windows Forms Control in Local Processing Mode
http://msdn2.microsoft.com/en-us/library/ms251784.aspx
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"pcho" <pcho@.discussions.microsoft.com> wrote in message
news:48D5B693-BB64-49BB-839C-E2531D002723@.microsoft.com...
> Hi Bruce, I have read something in Microsoft's marketing material and I
> was
> wondering if you could clarify one point for me. The exact quotation is
> as
> follows:
> Visual Studio Integration
> In addition to creating reports in a Report Server project, report design
> is
> now completely integrated with Visual Studio language projects. You can
> embed
> reports directly in any Windows Forms or ASP.NET Web application. The data
> access options of embedded reports are a natural extension of the Visual
> Studio data facilities. Not only can you use traditional databases as a
> source of data for your reports, you can use object collections as well.
> Report Designer, as shown in a language project, is highlighted in Figure
> 9.
> The URL of the above quotation is:
> http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx
> In the second last sentence: "Not only can you use traditional databases
> as
> a source of data for your reports, you can use object collections as
> well.",
> what is meant by "object collections" here?
> Again, my objective is to report right from a collection of objects
> (simple
> or complex), no datasets, no web services, no XML, how do I do it?
> Thank you very much again in advance!
> Pierre
>
> "Bruce L-C [MVP]" wrote:
>> This will get you started:
>> http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.localreport.aspx
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "pcho" <pcho@.discussions.microsoft.com> wrote in message
>> news:7B54CB73-A909-483A-A340-29E2C1D8BEC8@.microsoft.com...
>> > Thank you very much for your answers Bruce. Could you please point me
>> > to
>> > the
>> > direction where I can find more information on local mode v.s. server
>> > mode?
>> >
>> > Thanks again!
>> >
>> > Pierre
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> I have used the local mode passing it a table (not a dataset, it wants
>> >> a
>> >> table). Reading the help there is the ability to use your own business
>> >> objects. Personally, filling a table is pretty easy and isn't a bad
>> >> way
>> >> to
>> >> go.
>> >>
>> >> Server mode you can do web service or create a data processing
>> >> extension.
>> >> I
>> >> am not aware of any other way in server mode to do this.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "pcho" <pcho@.discussions.microsoft.com> wrote in message
>> >> news:6D08FD6E-2055-4096-9123-14207F7CA7FE@.microsoft.com...
>> >> >I am also interested in finding out how to report off of my own
>> >> >business
>> >> > objects in RS2005. Is there a simple way, without going through web
>> >> > services
>> >> > or dataset, to use my business objects as datasource? Even a
>> >> > simpler
>> >> > experiment: how do I use a collection of simple objects (strings,
>> >> > for
>> >> > instance) as my datasource in RS2005? DataDynamic's ActiveReports
>> >> > allows
>> >> > you
>> >> > to pass a collection to a report as its datasoure without any extra
>> >> > work,
>> >> > such as going through a web service or transforming the collection
>> >> > to a
>> >> > dataset, etc.;
>> >> >
>> >> > Thanks in advance.
>> >> >
>> >> > Pierre
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> I think he means business objects not Business Objects (i.e. his
>> >> >> own
>> >> >> business objects not the company).
>> >> >>
>> >> >> Assuming I have the right interpretation you can create your own
>> >> >> data
>> >> >> extension that would allow you to do this but it is not trivial.
>> >> >> With
>> >> >> VS
>> >> >> 2005 and RS 2005 there will be two new controls: a webform and a
>> >> >> winform
>> >> >> control. They have a local mode where you had it a dataset and a
>> >> >> report
>> >> >> and
>> >> >> away it goes. Since you can create a dataset in dotnet out of
>> >> >> business
>> >> >> objects this should work for you. Note that local mode does have
>> >> >> some
>> >> >> limitations (for instance no subscriptions).
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >> "Carl" <Carl@.discussions.microsoft.com> wrote in message
>> >> >> news:F32A8134-66D3-438B-97B6-0E066051EF8C@.microsoft.com...
>> >> >> >I am not sure of the datasources of the previous versions of
>> >> >> >BusinessObjects
>> >> >> > but the current version BO XI uses a MySQL backend but you can
>> >> >> > use
>> >> >> > MSDE
>> >> >> > or
>> >> >> > SQL Server if you so choose. So as long as you can connect to the
>> >> >> > server
>> >> >> > with
>> >> >> > a valid login you shouldn't have any problems reporting off of it
>> >> >> > just
>> >> >> > like
>> >> >> > any other SQL Server database.
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > "Nicolas BRESSAN" wrote:
>> >> >> >
>> >> >> >> Where do you have seen that?
>> >> >> >>
>> >> >> >> It's marvelous if it's possible...
>> >> >> >>
>> >> >> >> Nicolas
>> >> >> >>
>> >> >> >> "Klaus Aschenbrenner" wrote:
>> >> >> >>
>> >> >> >> > Hi!
>> >> >> >> >
>> >> >> >> > I've read somewhere that it is possible to use business
>> >> >> >> > objects
>> >> >> >> > as a
>> >> >> >> > data
>> >> >> >> > source for the reporting services.
>> >> >> >> > Can someone tell me where I can find further information about
>> >> >> >> > it?
>> >> >> >> >
>> >> >> >> > Thanks
>> >> >> >> >
>> >> >> >> > Klaus Aschenbrenner
>> >> >> >> > MVP Visual C#
>> >> >> >> > www.csharp.at, www.anecon.com
>> >> >> >> > http://weblogs.asp.net/klaus.aschenbrenner
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

Business Objects and Microsoft Reporting Services

Hi,

I am evaluating Microsoft Reporting Services against Business Objects
as a reporting tool against SQL Server. I am primarily a BOBJ
developer and am finding RS not easy to use. Can anyone provide any
feedback to the overall comparison between these 2 products as I am
finding RS frustrating and am wondering if it is just a matter of
re-adjusting and spending more time on it or if anyone else is finding
RS more trickey to use than BOBJ as well

I would be extremely grateful for any feedback.

Many thanks in advance
LAHi

You may want to register for the Reporting services launch web cast on 27
January and the other information on the Reporting Services Website
http://www.microsoft.com/sql/reporting/

John

"lak" <kohliann@.yahoo.com> wrote in message
news:bed61cd3.0401141115.7d44d6ce@.posting.google.c om...
> Hi,
> I am evaluating Microsoft Reporting Services against Business Objects
> as a reporting tool against SQL Server. I am primarily a BOBJ
> developer and am finding RS not easy to use. Can anyone provide any
> feedback to the overall comparison between these 2 products as I am
> finding RS frustrating and am wondering if it is just a matter of
> re-adjusting and spending more time on it or if anyone else is finding
> RS more trickey to use than BOBJ as well
> I would be extremely grateful for any feedback.
> Many thanks in advance
> LA

Business Objects and Db Performance

I'm new to Business Objects, and I have a question to ask,

Does creating universe in the designer actually creates indexes in the DB? Or universe is just a reference model for the BO app.

If so, won't poor designed universe slow down DB performance?

For those who have experience in BO, please advise. Thanks.In my experience BO does not create any indexes in the DB. And yes, universe design is very important as poor universe design will lead to poor performance.. I am using BO 5.1.?, I'm not sure what version you are using.

Any more questions please let me know.

Thanks,

Originally posted by Patrick Chua
I'm new to Business Objects, and I have a question to ask,

Does creating universe in the designer actually creates indexes in the DB? Or universe is just a reference model for the BO app.

If so, won't poor designed universe slow down DB performance?

For those who have experience in BO, please advise. Thanks.