Search results for query: *

Hi! My prompts are 1: drop-down from query (single selection/required), 2: drop-down from query auto-submit (single selection/required) default value set from static collection in prompt and 3: list-box cascaded from prompt 2 (multi-select/optional). I've run the report with a multi-select in...

Hi! I'm trying to duplicate the behavior and my prompts reset to defaults after using the "Run" icon. Can you please tell me what type of prompts they are, do you have a static default value set? thanks...jean

Hi! When you say the users run the report a 2nd or 3rd time, are they running it from the link in Cognos Connection or from the "run" icon that's shown when the report is displayed? If they're running it from the link, you may need to disable their write permissions so that the prompts don't...

Hi! It could be the dreaded pop-up blocker behavior. Have you checked and added your site in the allowed lists that most blockers have? hth...jean

Hi! I looked at the .ldif file that gets created from db2ldif.bat to backup my Directory Server and the authid that's shown in Cognos Connection is not there. Any chance you can get your company to purchase the SDK?? jean

Hi! This has worked for me. "mart" is the Series 7 (Sun) namespace in ReportNet. Userclasses are seen as roles by the SDK. String martRolesPath = CAMID('mart')//role"; PropEnum martProps[] = new PropEnum[]{ PropEnum.searchPath, PropEnum.objectClass, PropEnum.name...

Hi! You can also use a .ldif to reinitialize the data if you've run the db2ldif.bat file. I would also suggest a reboot of the server between the deinstall and reinstall. Then you can reuse the port (389) and not have to change config. Also, have you run AM_NamespaceCorruptionDetect from the...

Hi! Has anyone been able to retrieve the dataBlocks from the ReportNet content store using the java SDK? I am able to change the cube name using the SDK but the cube name is embedded in the dataBlocks too. When I try and get the dataBlocks, I get a "No deserializer" error. Any help is...

Hi! If you can log on as the "ReportCreator" user, you can open the properties of the report and there is a link to "Make me the owner". Another way would be to use the SDK. hth...jean

Hi! Open PowerPlay Server Administration, select your PowerPlay server then Edit=>Properties. Click on the Settings tab for Server Settings, make sure your Options is expanded. There is a "Prompt for User Class" in the list of options. Set this to "Disable" hth..jean

Hi! You need to add to the system.xml in templates/portal/ps <param name="ui_hide"> <CC_VIEW_TOOLS show="Administrators"/> </param> This will hide all the Tools for anyone who is not an Administrator This goes at the bottom before </system> jean

Hi! The "Admininstration and Security Guide" Chapter 18 shows how to hide user interface elements listed in Appendix E. I use the system.xml method. I hide the tools from all but Administrators. I'm not sure if you can hide the tools if you need finer granularity than the ID's provided by...

Hi! I modify the "title" area in \templates\ps\portal\system.xml to put out messages. The downside of this is that it takes a restart of ReportNet to implement. hth...jean

Hi! You can create a variable with type of String. In the expression editor (right top pane), do a decode/if then else/case to assign a color to the state for example decode(state_abbrev,'CA','RED','GA','ORA','MN','GRN'.... Then add each of the color codes in the Values section. When you...

Hi! I've created a data item with the dynamic text (current month name plus some literals) in the tabular model and query. I used this data item as the "Report Expression" for the column header. Click on the column header(usually the column name from the model) and click on the ellipses next...

Hi! Have you tried File=>Pages, click the page and the properties icon and set the page-break query to the query in your report? HTH jean

Hi! I create a calculation at the Tabular Model level with the text I want in the column heading. Open the "Query" window and drag the column from the Query Items to the Facts. Go to the report page. Select the column title (mine is a blue area usually with the column name). In the...

Hi! ReportNet comes with Framework Manager. a data modeling/package generation tool which can be used to generate iqd's. This is the "replacement" for Architect.

Hi! Most of my reports have an "Event Name" set on the "Run Options" of the report. I used the ReportNet SDK to create a java program that is run during our nightly CDW processing to trigger the event when all the data is available for the report. If you have the SDK, this should be pretty...