Search results for query: *

use the same username password as database username/password during firdt time informatica server setup. It will work.

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

Dave, I am using Teradata. I have tried your solution and it works fine. Thanks cogprog

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

What I want is something like nesting in the prompts. I am sure this is one of the potential requirements in any type of reporting scenario.Cognos is accomplishing it on RDBMS throgh Powerprompts. There's got to be a way to accomplish this requirement in MDDB's too. 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

John, Thanks for ur response. But here I am talking about the nested menu(DHTML menues if I figured them correct) dropdowns from the dimension boxes after we get a report in browser. Can we select 2 values simultaneously from these menues. 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...

Thanks for ur response . But situation is not that easy. As at the report time we are choosing the year so the value of current or prior year is never fixed that is why I can't apply the formula u suggested. cogprog