WhereScape Forum http://www.wherescape.com/Forum This is an XML content feed of; WhereScape Forum : Last 10 Posts Sat, 31 Jul 2010 16:49:34 +0000 Fri, 30 Jul 2010 21:08:50 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 8.02 30 www.wherescape.com/Forum/RSS_topic_feed.asp WhereScape Forum http://www.wherescape.com/Forum/forum_images\wherescape_logo_new.gif http://www.wherescape.com/Forum Ask a question or Report a Bug : Error creating OLAP Cube http://www.wherescape.com/Forum/forum_posts.asp?TID=3095&PID=9576#9576 Author: TerryM
Subject: Error creating OLAP Cube
Posted: 30 July 2010 at 9:08pm

Had the conference call this morning (UK time) and eliminated the error by removing all the Attribute Relationships from the OLAP Dimensions and recreating the cube. The customer will now put these back one dimension at a time to discover which Attribute Relationships are causing the original error.

]]> Fri, 30 Jul 2010 21:08:50 +0000 http://www.wherescape.com/Forum/forum_posts.asp?TID=3095&PID=9576#9576 Ask a question or Report a Bug : build get_..._ key db2 http://www.wherescape.com/Forum/forum_posts.asp?TID=3161&PID=9574#9574 Author: Support
Subject: build get_..._ key db2
Posted: 30 July 2010 at 5:39pm

Apologies, cancel that last!
Yes this does still occur in the latest Beta for dimension views. We'll see if this can be fixed for the final release of 6112

Identified as
OPENITEM RED-1719]]> Fri, 30 Jul 2010 17:39:05 +0000 http://www.wherescape.com/Forum/forum_posts.asp?TID=3161&PID=9574#9574 Ask a question or Report a Bug : build get_..._ key db2 http://www.wherescape.com/Forum/forum_posts.asp?TID=3161&PID=9573#9573 Author: Support
Subject: build get_..._ key db2
Posted: 30 July 2010 at 5:26pm

Gerry,
We have confirmed this no longer an issue in the latest release 6.1.1.2, now available as a Beta download.]]> Fri, 30 Jul 2010 17:26:17 +0000 http://www.wherescape.com/Forum/forum_posts.asp?TID=3161&PID=9573#9573 Ask a question or Report a Bug : Object Checked out not showing on report http://www.wherescape.com/Forum/forum_posts.asp?TID=3163&PID=9572#9572 Author: aaron
Subject: Object Checked out not showing on report
Posted: 30 July 2010 at 4:54pm

is it perhaps the difference between been 'checked out' through the checkout logic Vs the 'checked out' based on the object being 'locked' in edit mode?]]> Fri, 30 Jul 2010 16:54:25 +0000 http://www.wherescape.com/Forum/forum_posts.asp?TID=3163&PID=9572#9572 Ask a question or Report a Bug : Getting parameterised schema name http://www.wherescape.com/Forum/forum_posts.asp?TID=3082&PID=9571#9571 Author: Support
Subject: Getting parameterised schema name
Posted: 30 July 2010 at 4:21pm

Sorry about the delay Carol, we'll take a fresh look at this over the next few days.]]> Fri, 30 Jul 2010 16:21:33 +0000 http://www.wherescape.com/Forum/forum_posts.asp?TID=3082&PID=9571#9571 Ask a question or Report a Bug : New field: Object Checked out date http://www.wherescape.com/Forum/forum_posts.asp?TID=3164&PID=9570#9570 Author: fernando
Subject: New field: Object Checked out date
Posted: 30 July 2010 at 3:47pm

We need to be able to see when an object was checked out, as at the moment it just shows created and modified date but not the date it was checked out, only the user that checked it out.
It might already be stored on the metadata tables but it really needs to be displayed on:
- The sproc properties screen
- The Procedure object list
- The "Objects checked out" report
 
Cheers
 
]]> Fri, 30 Jul 2010 15:47:26 +0000 http://www.wherescape.com/Forum/forum_posts.asp?TID=3164&PID=9570#9570 Ask a question or Report a Bug : Object Checked out not showing on report http://www.wherescape.com/Forum/forum_posts.asp?TID=3163&PID=9569#9569 Author: fernando
Subject: Object Checked out not showing on report
Posted: 30 July 2010 at 3:43pm

Stored Proc checked out not showing on the "Objects checked out" report.
 When viewing the properties of the sproc it says "Checked out by Steve" in RED but when I run the report the report appears blank.
So either the report is broken or the report and properties screen seem to be looking at different things when checking if a sproc is checked out.
 
Cheers
 
Version 6.1
]]> Fri, 30 Jul 2010 15:43:01 +0000 http://www.wherescape.com/Forum/forum_posts.asp?TID=3163&PID=9569#9569 Ask a question or Report a Bug : Search for String sometimes returns 0 Hit Count http://www.wherescape.com/Forum/forum_posts.asp?TID=3162&PID=9568#9568 Author: fernando
Subject: Search for String sometimes returns 0 Hit Count
Posted: 30 July 2010 at 3:09pm

That's my results BTW, funny the first and last show 1 but the intermediate ones show 0:
 

Object name,Hit count,First match on 'dim_product.product_number',

update_stage_billing,1, AND ods_billd.bill_product = dim_product.product_number ,613

update_stage_invoice_detail,0, AND ods_invoiced.invoice_invoice_product = dim_product.product_number ,616

update_stage_order1,0, AND ods_orderd.order_product = dim_product.product_number ,1890

update_stage_product_location,0, AND ods_prodloc.prodloc_product = dim_product.product_number ,625

update_stage_product_serial,0, AND ods_product_serial.product_serial_prod_n = dim_product.product_number ,630

update_stage_sales_revenue_1,1, CASE WHEN (dim_product.product_number IN

,632

]]> Fri, 30 Jul 2010 15:09:49 +0000 http://www.wherescape.com/Forum/forum_posts.asp?TID=3162&PID=9568#9568 Ask a question or Report a Bug : Search for String sometimes returns 0 Hit Count http://www.wherescape.com/Forum/forum_posts.asp?TID=3162&PID=9567#9567 Author: fernando
Subject: Search for String sometimes returns 0 Hit Count
Posted: 30 July 2010 at 3:08pm

Also versions tested are 6.0 and 6.1 so don't think it's a version issue.]]> Fri, 30 Jul 2010 15:08:12 +0000 http://www.wherescape.com/Forum/forum_posts.asp?TID=3162&PID=9567#9567 Ask a question or Report a Bug : Search for String sometimes returns 0 Hit Count http://www.wherescape.com/Forum/forum_posts.asp?TID=3162&PID=9566#9566 Author: fernando
Subject: Search for String sometimes returns 0 Hit Count
Posted: 30 July 2010 at 3:07pm

Using the Tools/Search for string functionality and searching for a string like "dim_product.product_number" to see which sprocs refer to it, returns in this case a few matches on different sprocs saying 1 or 2 but some of them say 0 Hit Count instead of 1. Editing the procedure you can see that there is indeed an occurrence of that string inside it so it should be 1.

Trying other strings, it returns 1 as it should so not sure what the conditions are for it to show 0. I initially thought that 0 stood for 1 and 1 for 2 and so on but it's not the case.
My guess would be that in the formula to calculate that Hit Count number there's a substraction somewhere that's not working for all cases.
Anyway, not a major issue/critical fix but worth fixing as it confuses users.
Cheers
 
]]> Fri, 30 Jul 2010 15:07:24 +0000 http://www.wherescape.com/Forum/forum_posts.asp?TID=3162&PID=9566#9566