Search results for query: *

Hi, In Vista, when you right click a network folder, you have the option "always available offline" which is a feature of the sync center. Is there a way to make a folder "always available offline" using a command line and without installing anything on the computer? Thanks!

Hi, My goal is to create burst reports and copy them into specific folders defined by the burstkey. I know that by using stuff like CM.OUTPUTLOCATION, you can specify a system folder location to store your reports. But I want to keep these reports in the CRN datastore. Besides, the name of the...

Hi, I need to create a cube with 3 dimensions: Product, Time and Customer. This cube contains some measures that cannot be rolled up with the basic features of Transformer (sum, average, etc). I have to use external rollup, but it is my first time with this function and I'd like to be sure of...

I solved the problem. I don't know how this happened but the administrators group had no more rights to edit the registry keys under HKEY_CLASSES_ROOT. The problem is I didn't knew where to search to find these rights. Eventually, I opened regedt32 (I always use regedit) and there was the...

I forgot to specify that I am running under Windows 2000 adv server SP4.

Hi, I tried to replace my Oracle client 8.1.7.3 with the 9.2.0.1 I deinstalled the version 8 client and when I tried to install the version 9 client, I got this error message: Error in creating a registry key Permission is denied The log shows: Calling action w32RegActions2.2.0.6.0...

Some of our reports stopped working when I installed impromptu 7.1 MR2 in place of the 7.1 MR1. The reports that do not work anymore show the number of visits done by our sales reps per month. They always contain the same 3 fields for each month. The first field calculates the number of...

All right, I finally figured how to achieve this. Here is the solution: In the main report, the prompt is composed of 3 fields and the third one uses the report picklist (which also contains a prompt). So even if, in Impromptu, the first prompt that shows is the prompt from the report picklist...

Dear all, I know how to pass prompt values to a "simple" Impromptu report using something like: Set ImpRep = ObjImp.OpenReport("C:\reportfolder\Reportname.imr","prompt_answer_1|prompt_answer_2|prompt_answer_3_1,prompt_answer_3_2") This works fine as long as there...

Pedro, Thanks but the goal is to get a smaller PDF and that’s why I want these fonts out because I want to send them by mail. In my company every computer has almost the same configuration in order to use these kinds of "tricks". After some testing I realised that even if I create a...

Hi, I created a PDF file from an impromptu report without any font embedded. I used only Arial and Times new roman fonts in my report. It is perfectly readable on my server (windows 2000) but once it is displayed on my local computer (windows XP) the text is complete garbadge. It looks as if...

Hi, I know how to create a PDF from an impromptu report via Cognos Script. But the file is too big. I removed the fonts from it (via the configuration admin)but it is still too much. So I was wondering if there is a way to create the PDF without the bookmarks. I created a PDF and, using Adobe...

There is nothing wrong with my script and I don't know why it gives me an error message but Cognos gave me a way to make it work. To actually work, you have to put the lookup function in a user defined function and then call it from your derivation, it sounds stupid but it works. So you create...

I tried this script to create a derivation. The script is very simple; what I want to do is far more complicated. <------------ $SQLString := 'SELECT distinct &quot;SPEC4&quot; FROM &quot;S_SPEC&quot; WHERE &quot;SPEC1&quot; = 1 and &quot;SPEC2&quot; is null and &quot;SPEC3&quot; is null'...

Thanks, it is exactly my problem and your solution does work. I wonder why the option &quot;value if null&quot; in the &quot;element properties&quot; of the &quot;table delivery properties&quot; can not replace null values. I must do it in the SQL statement or else my data is rejected.

My fact table contains a field which is sometimes null and this is not an error. But this field is related to a dimension and so I must use the &quot;Include unmatched members&quot; option. I also use a lookup to insert the surrogate key of this dimension. I get a message during the build...

Ok, I found it! You must select the columns you want to appear as table. Then you go in INSERT -> NAME -> DEFINE, there you enter a name, table1 for example. Now, when you link to this excel file with the odbc, a table named table1 appears and you can query in it. Thanks anyway for your help...

Now that I think about it, the software is not an issue. What matters is that even with a basic SQL query there is always that table problem : &quot;select * from ???&quot;...

Impromptu from Cognos.

I have a simple excel file with 2 columns and I would like to access it with the odbc. I tried to configure the odbc for this task but when I want to perform a query I have a message telling me that there is no table to add to my query. So I assume that there is a way to define tables in a excel...