Search results for query: *

Anyone know what kind of problems to expect with this ? Have noticed some problems with joins and aliases not migrating across sucessfully via the utility and was wondering if anyone knew of any likely pitfalls with catalogue / report migration to ReportNet. About to start migrating reports...

Anyone out there who's done a migration who can contribute ??? Ideally looking for specific examples of things that don't migrate e.g. catalogue prompts, certain joins types etc. or anything that caused a headache. Any thoughts welcome !

I might have to justify that decision ! What sort of problems did you encounter and what problems does this cause in the long run ?

Hi, About to start migrating a 7.3 catalogue to 1.1 MR2 Framework Manager and was wondering if anyone had any tips or anything in particular to look out for. I've got as far as importing the .xml version of the catalogue into a new framework model / project using the migration utility...

Hi, Several cubes have user class based restrictions, (apex, exclusions etc) The process for populating the models with user classes, views and restrictions is automated becuase there are loads of user classes and each user class view is slightly different. Does anyone know of the...

As a footnote, If I convert the query to SQL and manualy enter the parameters rather than adding values via prompts it runs as quickly as I would expect. I suspect its soemthing to do with selecting date ranges through prompts. Anyone have any experiance with slow query performance using...

Set Auto group and summarise to NO & set all individual filed properties to be the same but no difference. If I cut and paste the Native SQL from ReportNet into e.g. Rapid SQL the query take 1 sec to return results that in reportNet takes 1min...

anybody got any tips for speeding up query performance in ReportNet ? e.g. It takes 45 seconds to retrieve a result set in ReportNet, although it only takes 5 seconds if I use something more direct e.g. RapidSQL to run the exact same query.

Ok - misunderstanding on my part on some of the jargon :-) All working now, once I'd logged off anonymous access in framework manager and logged back into the new namespace. Many Thanks.

Isn't Netscape Directory server = iplanet = Sun One directory server depending on which bit of the globe you live in (?) - ref ebi_inst.pdf, Installing a directory server,p65 (UK) If not, what would you call a series 7 authentication provider ? Are you saying that Netscape Directory server...

Hi Damian, Have you checked that the PPClient settings under file, preferences, surpress are set to include zero values and divide by zero ? Cheers, Dave

All the users / user classes used in our series 7 installation are held in a Netscape Directory Server. Anyone know how to connect ReportNet to this source so that I can apply user and user class based filter restrictions within framework manager ? Think the connections defined in...

what prob's did you have going from 7.1 to 7.3 ? This is something we will be considering doing over here before too long.

you could create a list of all users who have used the application from the log file (that is if you have it switched on in Enterprise Server, think summary level would do) and compare this to the list of registered users within Access Manager. Easiest to import the log file into a table...

Thanks mukund, Wouldn't that just remove absolute duplicates though ? What I was after was an efficient method of removing records where the key value is the same but the status is different. (See above example) Someone else suggested doing a select max first on the status field and then...

Hi, Anyone know of an efficient way of writing a stored procedure that removes certain types of duplicate records? The source table I'm looking at contains records that are tagged with a status field containing one of 4 values. In some circumstances, a transaction exists in more than one...

Do you mean the user account thats used to run the IIS Admin Service..? Its set to local system account. I think the problem is that the server is on an old untrusted domain thats being phased out. All users and all IIS authentication is routed through a list on the new domain, which is where...

Hi, Need a bit of help with this one..... We have a server running IIS set to windows challenge response only. If I try to log in from my NT desktop it all works seemlessly, and I'm not prompted to sign in. However if I log onto the server itself using the same NT userID / password it...

Anyone got any experience with loading data into Cognos Metrics Manager..? We are finding it very slow to get data in via the table KPI_VALUE_STAGE. Anyone else get this, and if so did you find a way of speeding it up..? thanks.

i.e. a second time dimension. Technically this is a good solution, however users (bless 'em) often struggle when you give them more than one time dimension.....