Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Xantix

    batch to make folder "always available offline"

    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!
  2. Xantix

    How to copy Reportnet reports to file system?

    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...
  3. Xantix

    External rollup on multiple dimension

    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...
  4. Xantix

    Error in creating a registry key

    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...
  5. Xantix

    Error in creating a registry key

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

    Error in creating a registry key

    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...
  7. Xantix

    7.1 MR1 impromptu reports crash in 7.1 MR2

    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...
  8. Xantix

    Macro to fill multiple prompt windows in Imrpomptu

    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...
  9. Xantix

    Macro to fill multiple prompt windows in Imrpomptu

    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...
  10. Xantix

    No Font embedded in PDF = incorrect display

    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...
  11. Xantix

    No Font embedded in PDF = incorrect display

    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...
  12. Xantix

    PDF Bookmarks removal

    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...
  13. Xantix

    "Lookup" in Decision Stream Script is not working

    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...
  14. Xantix

    "Lookup" in Decision Stream Script is not working

    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'...
  15. Xantix

    Decision Stream, including unmatched members

    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.
  16. Xantix

    Decision Stream, including unmatched members

    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...
  17. Xantix

    How to access excel files with ODBC?

    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...
  18. Xantix

    How to access excel files with ODBC?

    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;...
  19. Xantix

    How to access excel files with ODBC?

    Impromptu from Cognos.
  20. Xantix

    How to access excel files with ODBC?

    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...

Part and Inventory Search

Back
Top