Search results for query: *

I've set a variety of roles the "ALLOW" option for individual Query Subjects. The list usually shows type-A, type-B and type-C roles. In different variations I'll give a table type-A the "ALLOW" permission and then save. We the deploy to production. Now when I go back to the above table...

Does anyone have, or where can I get a listing of all of the PS system tables and their functions?? Like PSSQLDEFN : shows names of all Application Designer created SQL objects. Steve N. State of Ohio, MIS

Can Report Studio warn a user, if they select one-or-more fields from 2 tables, prior to trying to run the report? That is: In your Package you have tables A, B, C. You create a join strategy (simple Equi-Join) between A and B. User selects field A1, A2, B1, then runs report....it's OK. User...

How complex, beyond simply equi-joining the primary keys of 2 tables, can you comfortably get? We'd like to ad a sub-query into the look-up tables' expression in order to get "effective-dated" information. Steve N. State of Ohio, MIS

I've just started the "join" strategy process for reporting in PeopleSoft. I need tips on properly setting up the embedded filters or expressions so that it handles "effective dating" properly between 2 tables. The EFFDT subselect is my stumbling block....How to do it? Steve N. State of Ohio, MIS

Can you modify the delimiter in the "save as" operation of saving the CSV output?? We might not want "tab-delimited" or "comma-delimited". I'll want to use a ~ perhaps (something that is NOT a character of the data). Steve N. State of Ohio, MIS

In ACCESS you can create report frames (portions of a report) that can grow/shrink depending on the size of a column's text value (including paragraph breaks). In IMPROMPTU, this would be a group-item header, where a description could be large or small. Is there a way to make the group-item...

Hi, The maniframe compiler, via SCLM, can create SQL Stored Procedures, but WITHOUT any "DECLARE EXIT HANDLER...." statements. If any "DECLARE EXIT HANDLER...." statements are present, the compiler returns the following: --------------------------------------------------- %DATASET --------...

When I attempt to import a target (DB2) table the Designer, using appropriate user-id and password to the database, then click <OK>....... I get kicked out of DESIGNER and end up on the Windows Desktop...(ouch ). This only occurs occasionally. What might be causing this "Kick-out" of...

I am attempting to use a Lookup with Dynamic Cache. The lookup is not working correctly. When I run the workflow with an empty lookup table, good insert. If I immediately run the workflow again, NewLookupRow is getting set to "1" every time, and I end up reinserting all rows again. What am I...

I can insert an OLE object, a supporting .pdf document, into an .imr report. When running Impromptu Client, you can click on the OLE link and get the .pdf doc to appear. This is not functioning the same way after publishing to IWR. Is this possible in IWR?? This is not a simple drill-thru...

1. COGNOS documentation of PPW suggests that: "To view explanations for individual cells in the PowerPlay Web display, right-click the cell, and then click Explain." 2. The * TIP says: "If an item other than an individual cell does not contain descriptive information in the Explanation window...

Our Data Warehouse/Mart is using DB2 Partitioning. Outside of always using prompted reports, which work fine, how do you &quot;join&quot; correctly to get the SQL to include the use of the &quot;part_nbr&quot; (partition number) correctly? This becomes an issue when creating a general report or...

Is it possible to &quot;freeze&quot; the Column Headings in a CUBE so that they won't scroll off the screen when you scroll down the page?? Besides, changing the &quot;Rows per page&quot; limit at the bottom of the screen. Some users don't seem to like limiting the rows. Thanks.

I'm trying to transform a mainframe flat file to an ORACLE table. The transformation ends successfully, but NONE of the columns in the ORACLE table are correct. Not even the first column, first row, of the table. Mapping goes (VSAM)--> Normalizer --> Oracle What else do I need to check again...

I am having problems getting selected items from a catalog-prompt to show up on the Impromptu-Web-Reports report. The prompt values appear in native IMPROMPTU and saving the .imr report as a .pdf, but.......when the IWR is generated, the catalog-prompt values do not show...... Anyone have the...