Search results for query: *

Hi, I have Transformer V7.0 and V7.3 installed on my machine, but in order to get one or the other to work I have to reinstall object store to the version I am using. Has anyone got two version on the one machine working without this. Any info would be welcomed!! cheers Mayo

Hi, Try this select username, count(distinct ticket) from yourtable group by username Mayoman

Hi Barry, I am unsure if you know what I am geting at. I would create an iqd with this syntax below and import it into the cube model. Add the dimension and apply this same dimension to the report title. The iqd syntax or should i say sql syntax would be: Select distinct (month(TODAY))-1 ||...

Hi, I am geting a bit confused on what your doing and what you are requiring. Do you have a time table, why not use this table to get your dates. Mayo for Sam

Hi, What I did is add a iqd with Today - 1 month which returned "2005.07". This is all the iqd returned - no measures or other dimensional data. I then created a new dimension and called it "Report Date" and this dimension was filled by the iqd above. I set the dimension to "always include"...

Hi, I did this where I wanted in the report title - current month - 1. The way I did it was allocate a dimension to the cube and allocated it to all measures and then added this dimension in the report title. It wasnt pretty but it did the job, the users didnt mind hope this helps mayo 4 sam

Hello, Why dont you use some functions to look for certain words like in unix "grep" for Transformer Server exiting - OK, if you get it then ok else error and send email. I do this for reading through database log files for errors, if it gets them send an email otherwise proceed with next...

Hi, Again I dont use ReportNet but I see why you are getting that amount 95.100.000. I think if you could get it in seconds 95100 you may be able to do something like below In seconds Day=86400 seconds (60*60*24:seconds:minutes:hours) hour=3600 seconds (60*60:seconds:minutes) minute=60...

Hi, I have never used reportnet so I am just giving a guess here but I remember doing something like this for a cube. I had a problem similiar but what i did was create the iqd by writing the sql myself and I never used impromptu at all. I did something like for months: Year(date) -...

Hi, Off hand dont think this is available. I would think you may have to do some precalculating in your database and bring in the fact that way. mayoman

Hi, I am a bit surprised that you are not getting errors when you create you cube with Patient ID set unique and it not unique. Is the uniqueness verification under properties on the data sources unchecked? I think you may have to delete the way you get the measure doing a category count on...

Hi, Dont know did you get this sorted but did you run the Access Manager - Configuration Wizard so that the transformer models know which authenication source is. mayoman

Hi Draoued, Got it sorted cheers for the reply anyway. It was to do when the ldap server was installed it created a default directory server on port 389. Cognos products could not connect to this default directory server. I reinstalled Sun One Ldap server and set the port to 1389 for the...

Hi, I have installed Sun(TM) ONE Directory Server 5.1 SP1 (formerly iPlanet(TM) Directory Server) on unix. I have all the respective cognos products installed. However I have configured cognos products and set the directory server to the name of the machine, port and dn. When I test the...

Hi, I have a stored procedure that is something like this FOREACH INSERT INTO ... SELECT -----; UPDATE ---- INSERT INTO ... SELECT ----- .... END FOREACH My question is do I need to set the SET PDQPRIORITY; before each query in the SP or just applying it before the first query and all the...

Hello, I had a similar request to show in the reports that the data in the cube was up to the previous month from the date the cube was created. I could not find no way to added in the title of the reports so I put in an another IQD with just one field of data that was the previous month and...

Hello JGirl, Thats very funny cause I know when you specify the format of 0% it multiplies by 100 but you normally compensate by setting Output scale to 4, have you though about taking the figure in as a whole ie 909 and setting the format with output scale and precision to 4 and 2 so you get...

Good comments but I would also add that I think by looking at your SQL and your model and analysing these could possibly give you great performance results in the case of using "unique" and breaking the queries up into Structural and Transactional, so as to eliminate needless processing for...

Why not just allocate them as unknown where a level in the dimension is not populated eg in the sql: case when .... is mising then 'Unknown' else ..... or in the blank substitution of the respective dimension level properties instead of blank. If you aint got the data there is noting you can do...

Hi JGirl, Have you tried Input scale 0 Storage type 64 bit output scale 4 precision 2 Format 0% and decimal 2 Mayoman