Search results for query: *

All, I am trying to connect from my UNIX PowerPlay ES to an Essbase cube. I created the PowerConnect file on my local PC and things look good. The OLAP Server Connection Guide says to copy this file to the UNIX box and create an entry for it in the PPES admin. I did this, but when trying to...

1. Go to Configuration Manager 2. Open the current configuration 3. Under "OLAP Data Access" --> Choose "3rd Party OLAP Server" 4. Put a 1 in the "Hyperion Essbase" property value 5. Validate and apply You should now see Essbase in the Connector - Database...

The easiest thing to do is: 1. Create a date dimension using the Date Wizard 2. Create a separate time dimension to hold the "time" part of the date. This part may have to be manual. It is easier to accomplish if you "time" part is in 24HH format.

Use the shell script outside of the control file to rename your "changing" file names to something standard. Then use this standard name in the control file. L

We have not been able to find a way either. I believe that this page is generated dynamically and the colors, images, etc. are hardcoded in whatever script generates it. Good thing is Series 7v2 has a "folder" like selection for the web version. Hopefully, this...

Sounds like a PATH problem. Make sure you have ORACLE_HOME set in addition to other Oracle variables. Then make sure ORACLE_HOME/bin is in your PATH. You really should consult the setup and installation guides. If you do not know how to set the PATH, then you are going to need a basic UNIX...

Each time you DBMS_OUTPUT, the text is written to a buffer. The buffer is not flushed until the end of the stored proc. Since the default since of the buffer is 2000, you reach that limit at about 350 iterations (6 bytes * 350 = 2100 bytes). You can up the 2000 limit by doing a...

As far as I know SQL*Loader is only executeable from the command line. Any command you execute from a command line, can be executed from a script. If you are new to SQL*Loader, take a look at the following: http://download-east.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/ch04.htm#644...

If you are running on UNIX... The easiest way is to replace the file name in your control file with a made-up character bracketed variable. For example: ^inputfile^ Then use a tool like "sed" in a script to create a new control file from the old one, replacing instances of your...

As far as I am aware, there is no API to interact with SQL*Loader. You will have to perform a system call to the OS and start the tool. If you have not used SQL*Loader before, then you should be aware that it loads flat files to the database. You will have to create a SQL*Loader control file...

Depends on your orgs training budget... If there is not budget, then the series of help PDFs that are installed with the production offer a good intro. They are all titled &quot;Discovering <product name here>...&quot; If you have money for training, the intro classes are great. Check out...

I have come across this problem also. There is a doc in the Support knowledge base that describes the fix. It is article #109341. Lonnie

Here is sample code from a macro I wrote: ' Create report object Set objPPRep = CreateObject (&quot;CognosPowerPlay.Report&quot;) objPPRep.Open( <path to report here> ) Set objPDF = objPPRep.PDFFile( <PDF file name here>, True) With objPDF .SaveEntireReport = True .AxisOnAllPages = True...

Ooops! Answered my own question: When searching for a dimension using Change, the method does not search up the dimension tree. Thus, to be sure you find what you are looking for you have to navigate to the top of the tree (ChangeToTop) and then execute the Change method with the value you are...

I am trying to create a simple PowerPlay macro that opens a report, changes in the dimension filter, and saves as a PDF. I have tried the simple example in the documentation, but I continue to get the error: R440 &quot;PowerPlay: The macro could not find the dimension matching passed...