Search results for query: *

Lets say I have Pline, Ptype, Pname I need to find total(measure1 for Pline), total(measure2 for Ptype) I created a similar calculation but the summary doesn't seem to happen at Pline level/Ptype level. What needs to be done? Prasad RPrasad1@Chn.Cognizant.com

Using a Macro, Is it possible to read the contents of the report header? Say all the text frames available on the header. Pls let me know if its doable Prasad RPrasad1@Chn.Cognizant.com

I have a table with few rows and cols. I have text frames inside each cell. Except for the first page, I want this table to be removed. I did that using a condition and made box type-none but doesn't work. any suggestions? Prasad RPrasad1@Chn.Cognizant.com

Hi, I want to create a query subject out of a StoredProc. The Stored Proc has a varchar2 & 2 date values as the i/p parameters. Its not working for me. Any Ideas ???? Prasad RPrasad1@Chn.Cognizant.com

Hi, While viewing a Published Cube in the Upfront, a String &quot; Cognos PowerPlay Web Explorer <Cube Name>&quot; is seen. I need to remove this. Unlike the published IMR reports, these cubes don't use the UTML Files. Do anyone have a solution for this? Thanks, Prasad...

Hi, When publish a cube, I see the output in HTML format. In the sameway, if I publish a PPX report, the ouput that I get is in PDF format. But I need it in HTML format. I don't see anywhere an option to change it to HTML format either in upfront or in the PPES screen. Pls let me know how this...

Hi, I have an IMR which internally uses Decode function of Oracle. When I save that as IQD, instead of Decode, CASE is used. I tried changing all the INI settings like, [Query Options] parameter, Case_To_Decode=T etc.. but still the probs exists. IMR is fine, but IQD is not. Does anyone have a...

Hi, I get the following general exception error when I am trying to include more than 3 filter conditions using the same prompt.The prompt is a report level promt. I cannot figure out y this is happening.Can someone help!!!! Thanks, K Rajkumar Error number -239: DMS-E-GENERAL, A general...

Hi All, I have seen many postings regarding Impromptu & SaveAs Excel with Format but still here I am asking once again ..... Our guys have a macro that has to be scheduled to save an Impromptu report to XL. SendKeys is used to save it as Excel with Format. But it doesn't seem to workout if...

Hi All, In powerprompts we use rs.open(QRY,UId,pwd,DBName) to open a recordset. If the application is moved to production & if we have to change the Database username & pwd, we change that manually by opening the powerprompt code. Is there any way in which AccessManager can be linked here to...

Hi All, I have published IMR report. Column titles are set to MultiLine WordWrap. But still, if I see it in XL, in the row containing column titles displays, only first line of the title is visible. I have to manually drag the height of the row to view the full title. Is there any solution...

Hi All, I have a sub-report with a main query and another query. The report contains two prompts say p1 & p2. Both the queries use p1 & p2. I want to set p1='value1' & p2='value2' for both the queries from powerprompt. From powerprompt I am unable set values for the prompts used by second...

Hi All, We have our Cognos Server in U.S. It's being accessed by clients in US & UK to view their reports. Number formats differ for both. It has to be xxx,xxx.xx for US & xx,xxx.xx for UK clients. Earlier, I saw a similar thread in which Dave Griffin has said that prompts have to be used &...

Hi, I have a Powerprompt report published. In the upfront, I have changed the display format to Excel in the Properties link under the ReportName. In run-time, I am changing the TEXT of a text frame in the header using powerprompt. The report looks perfect in PDF format. In Excel, I am not...

Hi All, I have a catalog called cat1 & a userclass called user1 in the catalog. There is a table called Emp. 'XYZ' is a empname in the table. Using macro, I should set a filter in the catalog for the userclass user1 to view only 'XYZ' details. How to acheive this using Macro?? Thanx & Regards...

Hi All, I have a list of UserClass & users in AccessManager. I want to make them as catalog-level users sothat I can set some filter conditions, prevent them from accesssing some columns etc. If I give the AccessManager Namespace to the Catalog, it's not opening in the very next time. How can...

Hi All, Here's are my problem: Our's is DWH project in which JSP & cognos is used. Users are created using JSP in the NDS(LDAP server). It is not getting reflected in the Access Manager but the other way is working fine. So, we r now thinking to use Trusted Signon Plug-In to ignore...

Hi All, Can I import a JSP page into Powerprompt dev. studio?? I have both IIS & Tomcat Server. Regards, Prasad.