Using Business Objects

Feb 28, 2008

Ok, probibly an easy question but I haven't been able to find what I am looking for.

If I have a simple class (see below), how would I make the People List avalible to build a report off of?

Thanks

asdf46





Code Snippetpublic class Person
{
public string FirstName { get; set;}
public string LastName { get; set;}
}

// and put them into a list
List <Person> People = new List<Person>();
People.Add(new Person () { FirstName = "Joe", LastName = "User"});
People.Add(new Person () { FirstName = "Jane", LastName = "Smith"});

View 3 Replies


ADVERTISEMENT

Business Objects Locking Problems

Mar 23, 2000

We have a user who uses Business Objects to run queries on the database. They are reporting that the query can lock the database up and that they were told at a conference that there is a setting which can aleviate this problem, but they are not sure if it is in SQL Server or Business Objects.

Anyone got any idea what they are talking about?

Colin.

View 1 Replies View Related

DR For Crystal Enterprise And Business Objects

Jun 12, 2006

Have to build DR solution and subj is a part of it.
Maybe some one has done it already€¦ share the experience please.
Dr in my case will between 2 different data centers, replication is san 2 san so on other side I have a warm standby that does not see san disks and will become active if and only if the primary data center is down, windows domain is the same, ip addresses, names of the servers are different. How a cluster will behave is interesting as well (I mean CE is on cluster, not geo distributed cluster).
I have CE90. I€™m talking to their tech support that seems to be outsourced, they didn€™t really produce in 5 days anything more then a part of their own documentation in pdf format for CE version I do not use J€¦
So I€™m wondering maybe somebody had to walk similar path already€¦


View 1 Replies View Related

Can I Use Business Objects As A Data Source?

Apr 3, 2007



We have decided to use business objects in our new application, which seems to be working well, since they can be used as a binding source for grids, etc.



I am trying to evaluate whether SSIS is a practical solution for our ETL requirements. The problem is, I can't find any examples or references, or even the slightest hint that anyone is using them with business objects. Any attempts to search yield a ton of results which are based on a commercial product called "Business Objects" rather than the design pattern.



It is currently a requirement of our development team that all data access must be done via business objects, rather than communicating directly with the database.



Can anyone provide some more information (besides just suggesting I write a custom connection manager)? Is there anyone who has actually made SSIS work with business objects?



Thanks, Richard

View 9 Replies View Related

Business Objects And Microsoft Reporting Services

Jul 20, 2005

Hi,I am evaluating Microsoft Reporting Services against Business Objectsas a reporting tool against SQL Server. I am primarily a BOBJdeveloper and am finding RS not easy to use. Can anyone provide anyfeedback to the overall comparison between these 2 products as I amfinding RS frustrating and am wondering if it is just a matter ofre-adjusting and spending more time on it or if anyone else is findingRS more trickey to use than BOBJ as wellI would be extremely grateful for any feedback.Many thanks in advanceLA

View 1 Replies View Related

Use Business Objects (generic List Object) As Datasource To Generate A Report??

Apr 2, 2008

I was wondering if it is possible to use a generic list object to use as the datasource/data for a report? Right now we use these business objects to display information on our website and would be great it we could re-use those objects and create reports based on them. We are doing some calculations etc in the business layer to build these objects, so if we could re-use, that would be best.
Thanks!

View 2 Replies View Related

Installing VS2005 And Business Intelligence Report Projects On A Vista Business Workstation

Oct 23, 2007

Does anyone have a successful prescribed sequence for installing VS2005 and Business Intelligence Reports Projects on a Vista Business workstation to be used to create reports for a server?

I've looked through everything I can find here and I don't seem to see a clear solution without a lot of trial and error.

Fact is, I've not been successful getting just the reports to install on a plain XP box. Of course, the report creation looks fine on the server but I don't want to work directly on the server.


Thank you

View 1 Replies View Related

Synchronization Of Business Contacts In Outlook With Small Business Accounting

Jun 10, 2006

Can anyone take me through synchronization of contacts within Business Contacts Outlook into Microsoft Small Business Accounts?

I run a stand alone PC with NO network. When SBA came SQL was also installed. Apparently you can synchronise Contacts within Business Contacts with SBA but both SBA & Outlook should work through the same SQL server.

Has anyone tried this?

Can someone walk me through the process?

Thanks

Debbie

View 1 Replies View Related

Putting Names Of Objects To Control-flow Loop Creating Objects

Dec 27, 2006

please help newbieI need to create a lot of objects the same type (let's say: schemas)I wish to use paramerized block in loop to do so.- how to put names of my objects to such control-flow?belss you for help

View 5 Replies View Related

SQL Server 2012 :: Select Data From XML - Objects Within Objects?

Nov 20, 2013

passing serialised objects to a stored procedure for the purpose of data inserts. I see this as being a way to handle multiple row inserts efficiently.

However, in my limited use of XML data I am not so sure how to link the data when I have a dependency on another "object" within the serialised XML.

Below is a code snippet showing what I have so far.

The first insert statement works fine - but how to retrieve the identifier created by the DB - I want to use an SQL statement that finds the record in the table based on the XML representation (of the PluginInfo), allowing me to insert the ConfigurationInfo with the correct reference to the PluginInfo

DECLARE @Config NVARCHAR(MAX)
DECLARE @Handle AS INT
DECLARE @TransactionCount AS INT
SELECT @Config = '
<ConfigurationDirectory >
<ConfigurationInfo groupKey="Notifications" sectionKey="App.Customization.PluginInfo"

[code]....

View 1 Replies View Related

Business Intelligence

Feb 10, 2008

 I had to do a re-install of SQL 2005 Standand Edition.  I
now do not have the BI, I do not know if it came with it or not. 
What would I need to install ifit did?  I also wanted to
ask:  I know that MS Office Excel has the capabilites to sames as
an XML file, but it is not very readable to import into the SQLdatabase.  Is there a way to import the XML file into the database via one of the express editions? Thank youDee 

View 1 Replies View Related

Business Days

Jun 20, 2008

dear gurus,

I want to get the working days between two days..
in a single query.

i will give the start_date '06-02-2008',end_date '06-13-2008' the result should be as below.


06-02-2008Monday
06-03-2008Tuesday
06-04-2008Wednesday
06-05-2008Thursday
06-06-2008Friday
06-09-2008Monday
06-10-2008Tuesday
06-11-2008Wednesday
06-12-2008Thursday
06-13-2008Friday


Thanks in advance.

cool...,

View 5 Replies View Related

Business Intelligence

Jul 12, 2005

I want to understand what is Business intelligence and what is functions of it

View 1 Replies View Related

Business Days

Sep 24, 2007

I Have a date range and i want to calculate the number of days - the weekends(saturdays and sundays) so that only businessdays are obtained.

A simple table's example:

Name, surname, datebeg, dateend

How can can it be done with sql?
BB

View 3 Replies View Related

Calculating Business Day

Aug 20, 2007

Hi,

I am wondering what is vb.net method of calculating the prior business day (Monday - Friday).

For example, if today is Monday, Aug. 20, the last business day would have been Friday, Aug. 17.

I have a way to do this in SQL, but not vb.net.

Thanks much

View 4 Replies View Related

SCDs With The Same Business Key

Apr 11, 2008

Hi all,

I've created a store dimension. Within the store dimension is a CityID column that is related to a City dimension. Currently this city dimension has the following columns:

CityID (primary key --- foreign key for the StoreDim)
CityName
CountyName
StateName
CountryName
...

My SCD's source is being loaded from a query to a Zip table that contains ZipCodes along with cityID, CountyID, StateID, and CountryID that can be joined out to their respective tables to find the information needed to populate my SCD. However, cities can have several number of zipcodes and several cities in different states can have the same names. This causes a problem with eliminating duplicates for my dimension as well as finding a suitable business key.

For example, let's take a case: Washington city, District of Columbia (county), District of Columbia (state), USA (Country)
Now, this city has SEVERAL zip codes so when I create my joins:


SELECT ...
FROM Zip Z
INNER JOIN City C
ON C.CityID = Z.CityID
INNER JOIN County Cty
ON Cty.CountyID = Z.CountyID


So this returns several CityIDs for the same city... which when I try to use for my SCD causes problems because i have several business keys based off my CityIDs so my dimension loaded would look like

CityID CityDesc CountyDesc StateDesc CountryDesc
1 Washington District of Columbia District of Columbia USA
2 Washington District of Columbia District of Columbia USA
3 Washington District of Columbia District of Columbia USA
4 Washington District of Columbia District of Columbia USA

I want to have just ONE record in my dimension for this city.... How would I do this and what would I use for a business key? Also any recommendations on which of these attributes should be historical attributes? I would appreciate any input you guys have.

View 4 Replies View Related

Business Intelligence

Jul 24, 2007

The Business Intelligence isn't showing up in the menu with ( Visual Basic, Visual C##, etc). A teckie installed the pro version and said she installed everything, can some one point me in the right direction. We purchase the media and installed from that.

View 2 Replies View Related

Business Logic File Needs Something...

Feb 26, 2008

Or maybe it can't find something it's looking for to make my additional symetrical with everything else. This is from one of my businesslogic files.  What causes Visual Studio to not allow me to add something here and have it behave like the other parameters/  I'm talking about ShortDesc.  Visual studio inserted () and the Get instead of GET like all the others.  It would not allow me to capitalize the "get". There has to be a reason for this. Currently my program is adding all of the fields except the ShortDesc to the table in my database. Does anyone have any thoughts as to why this is the case?
 
 #Region "Pvt Members"        Private _ArticleID As System.Int32        Private _UserID As System.Int32        Private _WebSiteID As System.Int32        Private _ArticleTitle As System.String        Private _Author As System.String        Private _ShortDesc As System.String        Private _ArticleText As System.String        Private _AnchorText As System.String        Private _ShowInDirectory As System.Boolean        Private _Active As System.Boolean        Private _DateAdded As System.DateTime#End Region#Region "Properties"        Public Property ArticleID As System.Int32            GET                Return _ArticleID             End Get             Set(ByVal Value As System.Int32)                _ArticleID= Value             End Set         End Property         Public Property UserID As System.Int32            GET                Return _UserID             End Get             Set(ByVal Value As System.Int32)                _UserID= Value             End Set         End Property         Public Property WebSiteID As System.Int32            GET                Return _WebSiteID             End Get             Set(ByVal Value As System.Int32)                _WebSiteID= Value             End Set         End Property         Public Property ArticleTitle As System.String            GET                Return _ArticleTitle             End Get             Set(ByVal Value As System.String)                _ArticleTitle= Value             End Set         End Property         Public Property Author As System.String            GET                Return _Author             End Get             Set(ByVal Value As System.String)                _Author= Value             End Set         End Property        Public Property ShortDesc() As System.String            Get                Return _ShortDesc            End Get            Set(ByVal value As System.String)            End Set        End Property        Public Property ArticleText As System.String            GET                Return _ArticleText             End Get             Set(ByVal Value As System.String)                _ArticleText= Value             End Set         End Property         Public Property AnchorText As System.String            GET                Return _AnchorText             End Get             Set(ByVal Value As System.String)                _AnchorText= Value             End Set         End Property         Public Property ShowInDirectory As System.Boolean            GET                Return _ShowInDirectory             End Get             Set(ByVal Value As System.Boolean)                _ShowInDirectory= Value             End Set         End Property         Public Property Active As System.Boolean            GET                Return _Active             End Get             Set(ByVal Value As System.Boolean)                _Active= Value             End Set         End Property         Public Property DateAdded As System.DateTime            GET                Return _DateAdded             End Get             Set(ByVal Value As System.DateTime)                _DateAdded= Value             End Set         End Property #End Region

View 1 Replies View Related

Number Of Business Days

Mar 22, 2001

Is there any easy way to calulate number of business days between the 2 dates ?
I want to exclude all sat and sun between the 2 dates.

View 1 Replies View Related

Calculating Business Hours

May 10, 2006

I am trying to calculate business hours that an order that is open. The rules are 8am-5pm. For instance the first row, the clock would stop at 17:00, and pick up again at 8am and add on to total business hours. If the order was created after business hours, and the endstamp was before business hours, this would be 0. If created after 5pm friday, and the endstamp was before 8am monday, this would be 0. In the second set of timestamps I have here the order was recieved at 14:39 but took until the following day at 14:49 to be ordered. I imagine I have to use datepart and datediff for this, but other than that I am not sure on how to do it. Any help would really be appreciated!



StartStampEndstamp
6/27/2005 14:356/27/2005 17:41:11
6/27/2005 14:396/28/2005 14:49
6/27/2005 18:486/27/2005 18:54
6/27/2005 11:416/27/2005 11:45

View 7 Replies View Related

DATEDIFF For Business Days Only

Aug 16, 2007

I'm looking for a DATEDIFF function which will give me the
BUSINESS days difference between 2 dates.
e.g: datediff(day,'08/08/2007','08/14/2007) would normally result in 6 (i think), however in business days this would be 4.
is there such a function?
Thx

View 4 Replies View Related

Business Intelligence Top 10 Issues

Mar 3, 2008

Interesting news article

http://www.theserverside.com/discussions/thread.tss?thread_id=48599

View 1 Replies View Related

Computing Business Hours

Mar 16, 2004

I am attempting to compute Service Levels for an interaction based upon business hours. For example, an email arrives at 4pm and is handled the following day at 10am. Call Center Hours are 8-5.

Essentially I have a number of different alternatives, and have found some potential solutions, including:

www.dbforums.com/arch/7/2003/9/914261

However, my situation has a couple of additional twists to the standard 8hrs of business M-F. The call center is open different hours depending upon the day of the week. For example, 8-5 M, 10-7 T, 8-5 W Th F, 10-2 Sat, 10-12 Sun

Additionally, I would like to remove Holiday's from the calculation for service level as well.

I have explored a number of different table DTD's, but none seem to be a perfect fit for determining the number of "open" hours between when an interaction arrived, and when it was handled.

The DTD I have for the Holiday table is as follows:

CREATE Table Holidays (HolidayDate DateTime)
GO
Insert Into Holidays (HolidayDate) Values ('12-25-2004')


Please let me know what you feel would be the DTD for storing the business hours and also the query for extracting the number of Open hours between two dates

Thank you in advance

View 13 Replies View Related

Defing Business Processes

Feb 12, 2007

Sorry, didn't quite know where this should go.
I'm reading Kimball Group's "Microsoft Data Warehouse Toolkit"
Has anyone got any experience in defining business processes? I'm struggling a little to look at my employer's recruitment busines and work out exactly what the real processes are.
Or maybe one of you has read something somewhere about this specific skill?

------------------------
Me: What do you want to know from your data warehouse?
Client: Err...Emm...Everything
Me: OK, that's great. That's all I need to know. I'll see you when it's done.

View 2 Replies View Related

SQL Business Intell. Dev. Studio

Nov 8, 2007

SQL BI Dev Studio is installed our SQL 2005 Server, however, it also needs to be on the person who is developing reports. I've already given her access to the sql db she will be working with. Can I install just the BIDS be installed on her desktop from the SQL CD?

View 1 Replies View Related

Want To Calculate Business Hours

Nov 8, 2007

hi Everyone,

I have one query, i want to calculate the business working hours (like from monday to friday 9 to 5 pm and saturday 9 to 2 pm) for the given dates. And also i want to eliminate the public holidays with in the given dates.



If any one was faced the same situation plz help me.




Regards

Venki

View 3 Replies View Related

Not Seeing Business Intelligence Projects

Dec 16, 2007



Hello everyone..

Start with a Vista Ultimate laptop running in x64. VS 2005 loaded second in x64 mode and sql 2005 developer loaded with everything in x64 mode.

I see the x64 service running in the sql server configuration manager but I don't see business intelligence project under sql server in the start menu or as a type in VS 2005.

Please help.. I love SSIS

View 5 Replies View Related

Business Intelligence In SQL Express?

May 5, 2006

Hello,

I have spent about half an hour looking for an answer to this, so apologies if I have missed it.

Can you get Business Intelligence Development Studio together with SQL Server 2005 both in Express editions? There was mention of an Express toolkit which includes BIDS but it seemed to imply you couldn't combine it with SQL Server Express.

If not, what is the cheapest way for an individual to get Business Intelligence Development Studio? My evaluation edition is about to run out.

Thanks,

View 1 Replies View Related

Business Intelligence On ROLAP

Aug 23, 2006

Hi all,

I am inquiring whether I can have some business Intelligence on Relational DBMS in SQL 2005 as projecting the number of patients within a health care basing on the available data.

Please help me out.

Regards,



Ronnie

View 7 Replies View Related

SQL - Business Contact Manager

Jun 8, 2006

I downloaded Business Contact Manager. With the download an SQL server is part of the download. When I rebooted my machine. The SQL server is not connected.



It's asking for:

Server
Service

How is this process completed to operate correctly?



Thank you,

Golf4Dee

View 3 Replies View Related

Business Rules Table

Aug 8, 2007

Which is the best practice for Business Rules


a. Hardcoded Column Names

b. Rowwise values RuleName, Criteria
Please suggest the best method

View 4 Replies View Related

Why Is Data Mining Use Too Little In Business?

Jan 11, 2007

Hello everybody,
 
There have been a lot of promising words around about data mining for (at least) the last decade. If one investigates how much data mining is applied in business, it can be concluded that this is rather limited. Currently I am investigating the possible causes of this limited data mining usage for my Master Thesis of Industrial Engineering and Management. This investigation includes a literature study and input a couple of experts from the data mining field.
 
Currently I want to check my results for two aspect with aid of other data mining practitioners:


 Is my analysis of possible causes complete (iow: what is missing?)

 Are the identified causes recognized confirmed or rejected by data mining practitioners?
 In order to proceed with my verification, I am looking for data mining practitioners, who are willing to give feedback on my work. I will send the participants a document with my findings to enable them to give their comments and other kind of feedback. (Or is it a better idea to start the discussion right here in this forum, let me know!) I think that my findings might be useful for every practitioner in the field and encourage you to participate.
 
Are there any people in this forum, who are willing to participate? In return you will receive my final results, which may be valuable for you as well.
 
Thanks!

View 3 Replies View Related

Business Logic In Store Procedure

Apr 5, 2006

Hey guys,I have to import a csv file to my database and then add
some values to other fields based on these values. At present I use a
store procedure that does a bulk insert and then I use an update and
fetch inside the sql to perform these updates. I am not sure if this is
the best way. Is this bad, since some amount of busniess logic is in
the store procedure?If it is, how can I do this better?Thanks for the answer.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved