Recent content by jvaneert

Hi there, Is it possible to automaticcally insert a date whenever a cube is created in the cube properties? (In the Transformer model) So that i can use in the report e.g. "MDC Description" which will shows the creation date then? Regards Jules

Draoued, I want 1 cube with the data from 4 sources included. regards jules

Hi there, For our 4 sales organization i make sales cubes. Eacht month i update 4 cubes. Is it possible to consolidate these cubes into 1 sales cube? Each cube is built with a query from a unique data source. So 4 datasources are queried for 4 cubes. What are the possibilities. Jules

Hi All, I am a newbie in macro's I want to save a impromptu report as an excel file and save the date in the filename. So each day i will have an export with the date in it. So for example List 1 28 februari.xls, list 2 1st march.xls Can someone please provide me with some macro code...

hi there, Whenever i open an impromptu report i am prompted with the question if the report should connect to the database on the catalog logon screen. Even when i have disabled the check box (always show this dialog). I want to skip the catalog logon prompt, but how should i manage that...

Hi DrLex, Thanks for your macro, it really helped me!

Hi DrLex. I am a rookie with macro's so i even do not know what the macro should contain. Could you gimme a example of something? Thanks Best regards, Jules

Hi All, Please help me, i want to have a macro that prints a powerplay report with the option fit to page. Does someone have some macro code which i could use>? Many thanks in advance. Best regards, Jules

Hello, I have a impromptu report which is run at night on the first day of the month. This report should include all dates from the month before. So eg. the 1-12-2004 report (DMY) should contain 1-11-2004 to 30-11-2004. how can this be calculated in an Impromptu formula? And off course the...

Hello, I am using a macro that saves a powerplay report as .pdf file per layer. So i use 20 layers and this results in 20 pdf files. Since "fit to page" is no option when exporting to .pdf i thought of using a "pdf printer", via this way i can use the "fit to page" option. But how do i add this...

Hi Dr Lex Thanks for your macro, i have adjusted it to my report and catalog name but when i run the macro it says : "MAC(25) Error: Unexpected end of file" What am i doing wrong Regards, Jules

Hello there, I am trying to save an impromptu report (Report A) on a daily basis as a hotfile. I want 5 hotfiles per week, e.g. for each working day. So Hotfile Monday, Hotfile Tuesday, Hotfile Wednesday, Hotfile Thursday, Hotfile Friday. I the week is over and it is mondat then the Hotfile...

Hello, I have a financial period table. It contains all 12 months and also a period 13. In total 14 periods. How can i add this in transformer? It only generates 12 date categories and invalid dates. Regards, Jules

Hello, I am querying a database with a period column. The periods are stored as following : YYMM So november 1998 is "9811" So september 2000 is "9" So oktober 2000 is "10" So march 2003 is "403" So november 04 is "411" Could someone provide me with an impromptu formula which converts these...

hello, Since i am a newbie to CognosScript could someone please provide me with a script that does the following 1. Open a Impromptu report 2. Save this report 3. Save this report as a HotFile 4. Close this report 5. Close the catalog. This procedure should be done for 5 different files...