Search results for query: *

I used my original XP CD to run an update against the existing installed version of the operating system. This ran into an error which when googled returned no information (anj3c7ys.sys not found) Now each time upon booting I get the option between the installed XP and a windows setup. Within...

Take a look at: http://www.ssas-info.com/analysis-services-client-tools-frontend Ties Blom

I'm trying to resolve a complex many-to-many model involving Units and Contracts: 1. Both tables store dimensional and fact related data 2. A unit can have 1 contract (which may be expired or not) or no contract at all 3. In most cases one contract relates to multiple units 4. In the rarest of...

We have an ongoing debate about the use of webservices as a ETL-source. Our application development engineers propagate using only a webservice as a source for extracting data. They would like to prohibit direct database access. We have experienced with SSIS and webservices and found it...

We're currently checking all in and out's to using xml as datasource in FM. Am I right in assuming that each xml file will have to be configured as a datasource? Did anyone run into (which) issues compared to using a relational datasource based on SQL underneath? Ties Blom

When restoring a database backup to an SQL server 2005 instance (9.0.1399 patch) all nvarchar and ntext columns are build with a specified collation type. (that should not be there at all) When restoring to 2 other SQL server instances (9.0.3077) the database is restored without specific...

If I use SPAN or DIV around an xml element than in HTML the message is shoed for about 5 seconds (on hover) However, it does not seem to performance twice without reloading the page. Is there a way to change this behavior (to persistent showing and being able to get the sreentip more than once)...

We really had to pinch ourselves today.. After installing a custom framework at a customer site we noticed that all shortcuts were stripped from the framework. That involved some shortcuts in the datalayer and ALL objects (except for namespaces) in the presentation layer. We checked the...

I'm trying to build a rather complex script to perform a scan on datadictionary tables. The purpose of the scan is to check whether certain tables are present and which ones contain no data. To achieve I store a reference set in a GTT. GTT's are stored in the temp tablespace. I wonder if I need...

Frameworks that contain more than 1 datasource keep throwing this error when trying the verify the model. Untill last week the verify action activated a dialogue-screen so one could choose the proper connection. Nothing has changed on the C8 server. Has anyone run onto this problem before? Ties...

I have an T-SQL script that reads some 660 with many occurences of a certain date calculation: CONVERT(DATETIME, CONVERT(VARCHAR(23), rdb.period_year * 10000 + rdb.period_month * 100 + 1), 112) Where rdb is the table alias used furtheron in the script. Can I define a variable like...

In a very rare case we need to simulate a full outer join between 2 tables. In the framework the relation is defined as an inner join and we would like to keep it that way. In BO (bus. objects) I used to generate such an effect by defining 2 queries and synchronizing the result-sets over the...

FM user guide is pretty straightforward on how to do this, but we cannot get it to work. I have 2 query subjects test and test2 Test holds dataitem C_DEPT Test2 holds dataitem N_DEPT I have added a filter to Test that reads: DEPARTMENT.C_DEPT = ?Choose department? Prompt info on C_DEPT...

Does anyone regocnize the following QS behavior? 1. Create a new report and drag a predefined (framework) filter into the report. This is set as a detail filter. 2. Perform action 1. on an existing report that already has a detail filter. Now the filter is assigned as a summary filter. Is...

In Oracle 9.2.0.1.0 we observe that the precision and scale are lost when doing a CAST in a view that contains an inline component (with the casting in the inner part) When the underlying table contains a field with number(10,2) then a describe on the view results in datatype number. Version...

Apologies in advance, cause I'm probably asking a bit much :) The challenge: writing a scan an repair procedure (in one or more steps) which should: 1. Scan a database (DWH-type) for FK's of the nullable kind 2. Process this information to perform succesive updates to a certain default for...

We have our development planning stored in MS Project. I would like to create weekly reports for each developer (resource) to give themn insight into what has been assigned to them. The reports should therefore contain: 1. Resourcename (developer) 2. Taskdescription 3. Startdate of the task 4...

We've noticed that Cognos 8.2 seems to randomnly assign the usage of identifiers / attributes to objects. This introduces different icons within the reporting tools and prompts questions from users. When should an object be assigned as an identifier? Does it make any difference to change the...

We are experiencing huge performance issues with fetching data from a linked Oracle database after upgrading the receiving database to Oracle 10g. It looks as though all data is first fetched at the receiving end, cause temp spaces are floaded. The query ran with no problem between 2 Oracle 9i...

Sorry to misuse this general forum, but the one specific for designer seems to be quite 'dead'. I'm looking for good resources to get the most from Designer 9. In general terms, I'm looking for a way to create one big DDL script from all tables and views (minus keys/constraints) from a specific...