Comments for Ross Goodman http://www.rossgoodman.com Me; What I Do; What I Like ! Fri, 17 May 2013 08:36:01 +0000 hourly 1 http://wordpress.org/?v=3.0.4 Comment on Dublin Marathon 2012 by Ross (Admin) http://www.rossgoodman.com/2012/11/07/dublin-marathon-2012/comment-page-1/#comment-94196 Ross (Admin) Fri, 17 May 2013 08:36:01 +0000 http://www.rossgoodman.com/?p=602#comment-94196 I just re-read your comment - as it's your first marathon I'd probably recommend Dublin; the crowd support will help you along. Crowd support makes a HUGE difference if you are flagging slightly! I just re-read your comment – as it’s your first marathon I’d probably recommend Dublin; the crowd support will help you along. Crowd support makes a HUGE difference if you are flagging slightly!

]]> Comment on Dublin Marathon 2012 by Ross (Admin) http://www.rossgoodman.com/2012/11/07/dublin-marathon-2012/comment-page-1/#comment-94195 Ross (Admin) Fri, 17 May 2013 08:33:17 +0000 http://www.rossgoodman.com/?p=602#comment-94195 Ohh - that's a difficult question to answer. Location wise: this was the first time I had been to Dublin, loved it and will be going back to do the touristy stuff rather than running. Chester, I have been there loads of times for both work and pleasure, I love the place. Pro's and cons: Dublin has fantastic support all the way round the course, there are only a few bits where there is no crowd support. In Chester the support in the town it's self and the towns you run through is great but a lot of the race is on rural lanes. Chester starts and finishes in the racecourse, last year it was quite wet, my feet got wet and I got my first ever blister through running! Next time I'll be much more careful where I'm walking and possibly carry dry socks to the start line! There is also a cobbled section just before you return into the racecourse which was murder on my ankles. Dublin, with a much busier start (well organised) took ages to get going, the toilets were VERY busy - you need to "schedule" that. I still can't choose: both are friendly and well organised; Dublin larger, busier city based; Chester more countryside and scenic. Let me know which you choose! Ohh – that’s a difficult question to answer.

Location wise: this was the first time I had been to Dublin, loved it and will be going back to do the touristy stuff rather than running. Chester, I have been there loads of times for both work and pleasure, I love the place.

Pro’s and cons:
Dublin has fantastic support all the way round the course, there are only a few bits where there is no crowd support. In Chester the support in the town it’s self and the towns you run through is great but a lot of the race is on rural lanes.

Chester starts and finishes in the racecourse, last year it was quite wet, my feet got wet and I got my first ever blister through running! Next time I’ll be much more careful where I’m walking and possibly carry dry socks to the start line! There is also a cobbled section just before you return into the racecourse which was murder on my ankles.

Dublin, with a much busier start (well organised) took ages to get going, the toilets were VERY busy – you need to “schedule” that.

I still can’t choose: both are friendly and well organised; Dublin larger, busier city based; Chester more countryside and scenic.

Let me know which you choose!

]]> Comment on Dublin Marathon 2012 by sarah http://www.rossgoodman.com/2012/11/07/dublin-marathon-2012/comment-page-1/#comment-94102 sarah Thu, 16 May 2013 13:21:34 +0000 http://www.rossgoodman.com/?p=602#comment-94102 Hi Ross! Just stumbled across your blog and enjoying reading about your marathon experiences last year! Well done for all the efforts ... very humbling! I'm struggling to decide between Dublin and Chester in October for my first marathon! Can you recommend one over the other?! Many thanks .. Hi Ross!

Just stumbled across your blog and enjoying reading about your marathon experiences last year! Well done for all the efforts … very humbling!

I’m struggling to decide between Dublin and Chester in October for my first marathon! Can you recommend one over the other?!

Many thanks ..

]]> Comment on Business Objects – Best Practice – Universe Design by Ross (Admin) http://www.rossgoodman.com/2009/03/01/business-objects-best-practice-universe-design/comment-page-1/#comment-88487 Ross (Admin) Thu, 04 Apr 2013 08:02:50 +0000 http://www.rossgoodman.com/?p=268#comment-88487 I assume that you have created your measure and made it conditional by adding a where clause. The contents of the where clause of an object will be applied to the overall where clause of the containing select statement. If you want the restriction to apply to just the object then you have to embed the restriction into the "select" portion of the object. For example, if you wanted to count open accounts but allow the query to also contain closed objects then you could define your object as: count(distinct case status when "open" then account_number else null) If the account status is open the account number will be counted if it is not open then the null will not be counted. NOTE: The query will be able to count closed accounts as well - we have to restricted the contents of the query. Hope that helps. I assume that you have created your measure and made it conditional by adding a where clause.
The contents of the where clause of an object will be applied to the overall where clause of the containing select statement.

If you want the restriction to apply to just the object then you have to embed the restriction into the “select” portion of the object.
For example, if you wanted to count open accounts but allow the query to also contain closed objects then you could define your object as:

count(distinct case status when “open” then account_number else null)

If the account status is open the account number will be counted if it is not open then the null will not be counted.
NOTE: The query will be able to count closed accounts as well – we have to restricted the contents of the query.

Hope that helps.

]]> Comment on Business Objects – Best Practice – Universe Design by Ramesh http://www.rossgoodman.com/2009/03/01/business-objects-best-practice-universe-design/comment-page-1/#comment-88469 Ramesh Thu, 04 Apr 2013 05:52:32 +0000 http://www.rossgoodman.com/?p=268#comment-88469 created a conditional measures using single measure at universe level and used aggregate aware on same measure. When I am creating a report I need to take some of the conditional measures in single query then when i am doing same thing what ever conditions applied on measures it is applying on whole query but i need those conditions on related condition measure only not on whole report please let me know if you have any solution. Thanks, Ramesh created a conditional measures using single measure at universe level and used aggregate aware on same measure.
When I am creating a report I need to take some of the conditional measures in single query then when i am doing same thing what ever conditions applied on measures it is applying on whole query but i need those conditions on related condition measure only not on whole report please let me know if you have any solution.

Thanks,
Ramesh

]]> Comment on The Great Gardening Project by Matt H. http://www.rossgoodman.com/2009/04/14/the-great-gardening-project/comment-page-1/#comment-87875 Matt H. Sun, 31 Mar 2013 07:05:06 +0000 http://www.rossgoodman.com/2009/04/14/the-great-gardening-project/#comment-87875 Looks like your garden is coming along nicely! I'm in the process of adding some planter boxes to mine to grow vegetables and herbs. Need to make sure to leave enough space between them so the lawn mower can get through.. Looks like your garden is coming along nicely! I’m in the process of adding some planter boxes to mine to grow vegetables and herbs. Need to make sure to leave enough space between them so the lawn mower can get through..

]]> Comment on Business Objects XI 3.0 New Features – Change Data Tracking by Pradeep http://www.rossgoodman.com/2008/05/20/business-objects-xi-30-new-features-change-data-tracking/comment-page-1/#comment-83870 Pradeep Mon, 11 Mar 2013 13:23:30 +0000 http://www.rossgoodman.com/?p=109#comment-83870 I see Track Change icon but it's disabled. I can't select it. What do I need to do to enable it? Thanx. I see Track Change icon but it’s disabled. I can’t select it. What do I need to do to enable it?
Thanx.

]]> Comment on Business Objects – Best Practice – Universe Design by Ross (Admin) http://www.rossgoodman.com/2009/03/01/business-objects-best-practice-universe-design/comment-page-1/#comment-79377 Ross (Admin) Mon, 11 Feb 2013 22:10:14 +0000 http://www.rossgoodman.com/?p=268#comment-79377 I'm not aware of a location in Business Objects where you can set a maximum number of connections. Depending on what database you are using this "may" be able to be set there. "does each request by a user will make a separate database call". If by "request" you mean report refresh then yes but a Business Objects "request" for example to sort or filter the data could work on a local dataset and not need to access the database. I’m not aware of a location in Business Objects where you can set a maximum number of connections. Depending on what database you are using this “may” be able to be set there.
“does each request by a user will make a separate database call”. If by “request” you mean report refresh then yes but a Business Objects “request” for example to sort or filter the data could work on a local dataset and not need to access the database.

]]> Comment on Business Objects – Best Practice – Universe Design by Ashwin http://www.rossgoodman.com/2009/03/01/business-objects-best-practice-universe-design/comment-page-1/#comment-79365 Ashwin Mon, 11 Feb 2013 20:23:48 +0000 http://www.rossgoodman.com/?p=268#comment-79365 HI Ross, Can you explain where do we mention the maximum number of DB connections in BO. Also, does each request by the same user make a separate DB call. HI Ross,

Can you explain where do we mention the maximum number of DB connections in BO.
Also, does each request by the same user make a separate DB call.

]]> Comment on Google Spreadsheet & SQL Queries by Robert K. http://www.rossgoodman.com/2010/04/19/google-spreadsheet-sql-queries/comment-page-1/#comment-78385 Robert K. Wed, 06 Feb 2013 15:27:22 +0000 http://www.rossgoodman.com/?p=451#comment-78385 Thank you. You just saved me hours of wasted time. Thank you. You just saved me hours of wasted time.

]]>