Search results for query: *

A prompt response is highly appriciated. I am using Series7 installation. The Powerplay Enterprise server and Transformer are installed on a QUAD Processor, 4GB RAM NT Machine. We (developers) do not have physical access to this server(We can not have something like PC Anywhere to administer...

I am trying to create a join between two database tables in a catalog to create a summary report. Join is something like ( where (A.DATE1-A.DATE2) Between B.Range1)) First of all I had a problems in having date minus date operation. Then I applied date-to-days-1900(date_exp)in both dates. It...

Hi, This is in continuation to my mail "IWR:User Class Missing or invalid". I have found out that only thoese IWR reports which are running against "REMOTE MS ACCESS" database are experiencing problem. While IMR's are running fine. I copied my source (MS Access) database...

Hi, I am getting an Application Error which says "User Class either missing or Invalid". I am using Series 7.0 suit. I have tried solving this by embedding username and password in the catalog. But its not working. Client IMR (in reportset/apps folder on server) works fine but on...

Hi, I have two schemas develepement(dev) and production(prod)I am creating catalogs on top of dev schema. prod is exact replica of dev. I need to point all my tables used in my catalog from dev to prod. Please suggest the way to accomplish it. Cogprog.

Hi, Is there any way to hide subtotals BY DEFAULT whenever a user "Accesses" the cube through upfront.I dont want them to see subtotals at all. Regards Cogprog

Hi, Is it possible to create interdependent dimensions? e.g. I have supervisor as one dimension and Employee as the other one. Requirement is something like this. When I choose a supervisor in a published powerplay web report (.pdf version) the next dimension (Employee) must show only those...

Hi, I want to display % of row total for each column along with the actual measure value in the powerplay report. When I am clickiing Explore->Show Value As %Of Row Total. I converts the origional value to % but I need The value too be displayed in adjuscent column. Report required looks...

Hi, What happens to categories when you recreate the power cube? Do they get recreated too or new cube gets created on top of old categories? What happens to categories if instead of recreating we update the cube? Cogprog

Hi, I need to display all the values in dimension dropdown list in alphabetical fashion in my powerplay(Client as well as pp web) reports. Please suggest if there is any way to do it? Cogprog.

Hi, I am running Series7 applications on a machine which is a personal web server too. I am facing a problem with drilling through from a Cube or Powerplay Web Report to an IWR. The cube drills through to imr "properly" in client applications. But when published, and drilled through...

Hi , I am using Series7 suit. I have published an IWR report. Properties of the report in report administrator show evrything correct e.g. catalog name and database accessed name. I am using access manager signons and have mapped all users to Creator profile which is a root user. When I am...

Hi, I have created a cube taking architect model as my data source. Also I have an .imr report with measure (Revenue) and dimensions(Region Name and Service Line) of same name in it. I tried to set up a drill through on this measure(Revenue) to the imr report. But on drilling the impromptu...

Hi , we are using Informatica powermart Ver4.7. We are trying to use a big table as a lookup. Powermart is taking too much time to get into its cache. Can we choose not to cache the table with "ver4.7" and still do the lookup. If yes , How can it be done. cogprog

Hi, Can anybody let me know if there is any way to make "multiple selections" enabled while navigating through the dimension values (filters) in an Impromptu Web Report.e.g. I can select only one office name in my office dimension selection combo. What if I want to select two offices...

Hi, I am having a perticular requirement in my report which needs the value of the dimension to be renamed depending upon one of its value. In my reports I always have to fetch data from 2 adjescent years. A prompt gives choice to user to select a year. Selected year(e.g.2000) as well as prior...

Hi friends, Can anybody let me know the scenarios when powerplay report bypasses the powerplay cube to fetch data from underlying database (RDBMS)? If exists... How can one prevent such situations? I am looking for a reporting solution where report never queries RDBMS at runtime...