Recent Posts

Pages: [1] 2 3 ... 10
Report Studio / Re: Conditional formatting & master detail relationship
« Last post by superdesi on 17 Nov 2017 03:33:20 pm »

Are the queries joined in the Query Explorer and the results of the join delivered into a new query? If so, why do you need to use a master/detail relationship in your report? Couldn't you just base your list on the query containing the results of the join?

If you have joined the queries in Query Explorer, have you tried changing the cardinality of the join to be optional (eg 0..n instead of 1..n or 0..1 instead of 1..1)?

You could then use a conditional format to highlight where the two address values do not match?


Hi there...

Just an update.  You were absolutely right. After changing cardinality.... It worked beautifully.

Thanks so much for ur help
Report Studio / Re: How to make the Active report in the middle
« Last post by ittimes on 17 Nov 2017 02:03:37 pm »
Active Reports Tip 4: iPad specific authoring

If you are authoring reports to be consumed by mobile users on iPads you should be aware of their native resolution. Reports should be sized to 1024px by 704px with the Page Body padding set to 0. This will minimize scrolling and truncation.

Active Reports Tip 5: Reducing Chart Overhead

In an active report, charts are not dynamically generated(this is for version 10.1, after v10.2.2 it is dynamic now). Chart views are rendered at runtime and stored within the MHT bundle. Chart heavy active reports could yield large output files. Keeping the charts to a minimum can help reduce the file size and improve performance of an Active report.

Extra Categories-for your to connect the chart without display the filter item. and In the Node’s properties, change the Category Range to Filtered Data.

HOW DO I ADD “ALL” TO THE DROPDOWN LIST?--Specify a default list item by changing the No Value List Item property to Show

 CAN I DELETE A CHART WITHOUT DELETING ITS QUERY? -- The answer is to Cut (CTRL + X) the Chart

When you have two or more reports open at the same time, it may seem like sometimes Copy and Paste works and sometimes it doesn't. Here are the "rules":
Copy and Paste currently only works in Internet Explorer
It only works for certain items. The common ones I use are Local Classes, Queries, and Tables (and their contents)
You can Copy and Paste a List/Crosstab/Chart only if the underlying Query also exists in the target report.

HOW DO I DETERMINE WHICH QUERY A RAVE CHART IS USING?--select the Data Container, now there is a Query Property.

if the user selected to re-prompt (re-loading the prompt page), wouldn't that trigger the OnLoad() again essentially replacing the user's selection with the default one again?
Reporting / Re: Drill-through
« Last post by rockytopmark on 17 Nov 2017 01:27:02 pm »
I wish I had a better resolution, but I resolved my issue by adding a 2nd drill-through definition.  Once I had 2 defined, the original drill definition now worked!  For kicks, I removed the new definition... the original drill stopped working again.  Finally, I removed the original, leaving only the new drill, and it worked as intended all by it's lonesome self.
Reporting / Re: Showing filter definition in report
« Last post by rockytopmark on 17 Nov 2017 01:15:48 pm »
Penny -

"this doesn't show the expression used in the filter.  Was it equal to, greater than?"

In most cases, the only thing that will ever change is the parameter Values... so you can simply copy the filter text into a report expression, and concatenate the parameter values.  For example, to show a filter on someDate...

To gets something in the report's output like:

'someDate = 2017-11-17'

...for the actual filter:

[namespace].[querySubject].[someDate] = ?p_someDate?

could be coded in a report expression, like:

'someDate = ' + paramValue('p_someDate')
'querySubject.someDate = ' + paramValue('p_someDate')
<whatever is desired>  + paramValue('p_someDate')

This way, the user knows whether it was = or > or <, etc...
Report Studio / Date Conversion
« Last post by rajurokz on 17 Nov 2017 01:05:59 pm »
Hi all,

I have requirement to convert the date format at report level,

Input date format - CYYMMDD
Output date format - MM/DD/YY,
Where C is century code When C = 0 then 19, C = 1 then 20 has to be displayed and the required date format is MM/DD/YY.

Please help me in achieving this requirement.

Reporting / Re: 11.0.8 Date functions broken?
« Last post by rockytopmark on 17 Nov 2017 01:05:15 pm »
current_date is still there, and as always, is only available in data item (query) expressions. 
AsOfDate() is available in report expressions only.

date2string() is only a report expression function and is working fine in 11.0.8.

string2date() is only a report expression function and is working fine in 11.0.8.

Reporting / 11.0.8 Date functions broken?
« Last post by Jeff H. on 17 Nov 2017 12:55:34 pm »
Hi all,

Has anyone had issues with the Cognos Report date functions? It looks like they've changed the behaviour of these and I can't get any of them to work.

date2string, string2date, current_date has been renamed to AsOfDate(). I wish they'd document this stuff. I guess that's too much to ask.

I noticed too that the cast function is gone from this release.

Announcements / Customization of Cognos BI
« Last post by on 17 Nov 2017 12:14:44 pm »
Hi experts,
When ever I try to run a report in excel , its get downloaded and then after reports get downloaded I don't want my report users to see the Runas and Saveas option icons. please help
TM1 / Simple TI process - Results have me Stumped!
« Last post by donap on 17 Nov 2017 10:56:08 am »
OK -- SO I still cannot Insert an IMAGE here... Please reference the attachment. ...
The image shows my  Dimension after an update - some fields in the SOURCE data got changed, and caused the Elements "601_input" ,  "622_input", "789_input", and "798_input" to become UNMAPPED from their correct Parents -- which appear under the Hierarchy - TOTAL --> DVU -->DU-->DUO-->NHC-->"601" ... etc.

As this could happen every time the scheduled job to update this dimension is run .. I put together a TI Process.
In my PROLOG TAB  I have the code shown below.

PART 1 - Works like a charm -- Moves Element "601_Input"  under the "601" Consolidated level in the hierarchy location as noted above.

When I   UN-COMMENT Part 2 -   (comment out Part 1)
The result is "Process completely successfully".  ** BUT NO ELEMENTS HAVE BEEN MOVED ***
The 4   "_input" elements are STILL in this same level (no ancestors) and the Corresponding 3-Digit Consolidated levels have NO CHILD elements !
What am I missing? Why is PART 2 not working as I expect ??  TIA

#Part 1 - TEST - Forcing Element to process
 sDim = pDim;
 sTop = pTop;
 sUnmapped = pUnmapped;

vChkElement = '601_input';
vParentLkup = SUBST(vChkElement, 1, 3);
vParIndex = DIMIX(sdim, vParentLkup);
 If (vParIndex <> 0 ) ;
    DimensionElementComponentAdd(sDim, vParentLkup, vChkElement, weight);

#Part 2 - Generic LOOP - should Identify Elements dynamically
# ==== vIndex = 1;

# ====WHILE (vIndex <= topCount);
# ====       vChkElement = DIMNM( sDim, vIndex );

# ====       if (DTYPE(sDim, vChkElement ) @<> 'C');
# ====                   DimensionElementComponentDelete(sDim, sTop, vChkElement );
#===                       vParentLkup = SUBST(vChkElement, 1, 3);
#===                        vParIndex = DIMIX(sdim, vParentLkup);
#===                       If (vParIndex <> 0 ) ;
#===                            DimensionElementComponentAdd(sDim, vParentLkup, vChkElement, weight);
 #===                     else;
# ====                       DimensionElementComponentAdd(sDim, sUnmapped, vChkElement, weight);
#===                      endif;
# ====        endif;
# ==== vIndex = vindex + 1;
 # =  end;

PS> Any hint on how to designate CODE  or insert the image would be helpful for future reference. When I click on the Insert Image Tool. it generates the "img" with brackets, but does not allow me to insert the image or reference the PNG file in between or anywhere else in this comment box.
Pages: [1] 2 3 ... 10