Search results for query: *

Hi, Environment: Sybase data warehouse - Framework manager / Reportnet in front of that and Windows XP Pro on my desk PC. I am rewriting a report that is based on an application which allows the user to do some pretty cool stuff - basically: define their own filter (as well as using all the...

We have the same problem as: thread401-261991 ...was this error ever resolved?

Hi there, Any one know how to get a group break on a crosstab repport in Impromptu? The groups button is greyed out and the help has no mention of groups when speaking of crosstabs. Am I attempting the impossible? TIA M

Hi, I have been asked to convert some 10 year old batch processes written QTP into summary tables in SQL which will then be used to generate cubes. Has anyone tried this before? Know of any good websites/documents that may help? I have no experience in QTP, in fact I first heard the word this...

Hi, Well, the title of my post basically says is all - I want to globally limit the number of rows returned in ReportNet and cannot seem to find where this is done. I know that it can be cone on a per report basis but I'd like to control it globally from one place. Any one done this yet? TIA M

There is only a creator role. I think navshiv is right, I may have looked at the SQL in the 'editor view' (not actually edited it mind you) ...crime of crimes. Hunting through backups/recreating the imr, testing and taking it live will take the rest of the week and it’s needed to generate cubes...

Hi, The data tab has diasppeared in one of my .imrs, when you hit the Query Data button in Impromptu you usually get the following tabs: Data - Sort - Filter - Access - Profile - Client/Server This particular .imr only has these: SQL - Group - Access - Profile Its probably something silly but...

Thanks so much! This thing of having to manually edit the cube each time a code changes was the last obstacle stopping us from implementing a batch file cube build strategy. The info in this post has given me more time to spend with my family at the weekend which is he real point of all this...

Hi, I have rather an annoying problem with one particular cube – from time to time, due to business changes it is necessary to delete and reinsert unique levels in a dimension. Basically the guys upstairs change an item code here of there and the next thing I have uniqueness violations when...

Hi, We have some users who are complaining that they erratically have ‘na’ in a cell of a PowerPlay report upon opening it. This seems to be in more than one report and I have personally witnessed the fact that it is totally erratic in that it happens without any discernable pattern. Has...

Hi there all you Cognos gurus! I have a few cubes that take up to 3 hours to sort the workfile - I know this because the log stops updating after the entry 'sorting the workfile' then starts up again a few hours after. I use iqd's as data sources in transformer based on data marts which in...

I am in the process of changing cubes to run against a different database (production only copy of a test database) and I see that each data source has a hardcoded signon. I am calling trnsfmr from command line in a batch file and was hoping that all I would need was to change the -k switch to...

Cognos series 7 WinXP Pro Hi, I am needing to enter the following calculation into transformer (by inserting column into the data source pane): if ("Score" < 50) then ('0-49(G)') else if ("Score" >= 50 and <= 99) then ('50-99(G)') else if ("Score" >= 100 and <= 124) then ('100-124(G)') else if...