Search results for query: *

You will be able to run it in Batch - just not from the GUI.

Hi, Your transformer models would be on the AIX box with the models I presume, the Unix command to build transformer is in the documentation, but here is a sample... cd /apps/home/cognos/shared/scripts ./CubeBuild.sh {usage} –a <Business/ Application> -m|p <Model_Name>...

Finally! After two days of trying everything, I used a Field Set in the page header to hold the Region field, an text block for ' = ' , and another Field Set to hold the count for each region (hide the caption and set the border to white). Works a treat, didnt have to use a Master-Detail query...

Hi, I have a simple grouped list report with four Columns grouped, the top one sectioned. I have a Count(incident) column not in the list that needs to be displayed in the Page header with the sectioned value i:e 'Region X = 100' When I page down, I need the data item (Region) in the Page...

Thanks - I am actually not looking to set the default value or default date, but rather limiting the 'Last Day' option so the calendar itself only goes until say the end of the year, no further. This is different from the default day which is the shadow on the prompt itself

I have looked everywhere but cannot find a method to use {CurrentDay -1}for example as the "Last Date" property on a Report Studio Date Prompt.It requires a hard coded date in date format. any pointers on this? Thanks

I have finished converting a DTS series of ETL builds to Cognos DecisionStream ETL and I would have to say that Cognos tool as much better functionality for handling heirarchies and surrogates plus it handles lookups and joins through its own internal engine so you dont have to keep repetitive...

I think you always offer the best solution (surrogates)and the reasons - to cover yourself when they invariably change their minds down the track. However if it is going to cause you grief arguing against a stubborn DBA, just make sure your case is documented and carry on with natural keys if...

How do you hide ReportNet drill thru reports from the user so they dont try to open them without the filter?

Some best practices for decisionStream are: -Create standardised naming conventions for columns and tables and catalogues.e.g D_dimension Table or F_Fact table - If using more than one catalogue, set environmental variables using batch scripts which centralises them. - Create a Dev and...

Hi, I have data in a table that looks thus: Event_number Risk_Code 1 A 1 B 1 C 2 A 2 D 2 G I need it to look like this: Event_number Risk_code 1 A B C 2 A D G Can this be...

Thanks Tsuji - works a treat - also thanks for 3rd party links guys.

No, it is for real - I have been tasked with constructing a daily batch file that runs through all application log files finding and replacing sensitive words.I am unable to use 3rd party tools due to security rules.

Thanks, but a restriction is that I am unable to use 3rd party software to perform this task.I will have to code it in Wscript or Dos

Hi, As a newbie I am trying to construct a batch file to find all instances of a a word "abc" in a bunch of log files and replace with "xyz". The Findstr command is great,but The replace command only seems to work at the file level, not the word/line level. Any ideas? cheers

Hi, As a newbie I am trying to construct a batch file to find all instances of a a word "abc" in a bunch of log files and replace with "xyz". The Findstr command is great,but The replace command only seems to work at the file level. Any ideas? cheers

I would like to use environmental variables in a Transformer macro to replace the username and password in the macro. What is the syntax to pick up an environmental variable? Is it possible e.g DIM username = {user_variable$}?

I have data as this:The Header is a parent of the Fixed. I need to filter out Headers whose ID = NULL, then take the number of the NULL header and filter out all other rows with that number (1041) in it. Is this possible without using a view or dataset filter? Datasets get corrupt on MR1 and we...

I have a Decisionstream build that produces a Ragged Dimension. Is there any way to pad out the heirarchy so missing values are copied down into each level to the bottom level?

I have exactly the same problem - I will try the BI Toolbox website and get back to you if I find an answer