Recent Posts

Pages: [1] 2 3 ... 10
It is no better on Firefox I am afraid. We are still searching, but there doesn't appear to be a workaround at the moment. Users who drill through to an underlying report in HTML often have to re-run that report as Excel - that functionality is no longer possible.

We have having to all new drill through links alongside the existing drill through links - just to add the open in Excel option. Not pretty.
I've been abroad for some weeks. I am unsure which report this is about, if it's still an issue. When I run into it, I will give more detail.
Reporting / (un)group repeating cells in excel
« Last post by vl9000 on Today at 07:29:17 am »
Hi all,

maybe this has been asked before but I could not find it.

Compared to Report Studio, it seems the report property "(un)group repeating cells when exporting to excel" is missing in Cognos Analytics?
Is this correct and is there a reason why it was removed, or can we expect to have it available again in a future version?
Or, if the option is simply hidden somewhere, could anyone pls guide me on how to find it?

Dashboards / Mapbox & Cognos
« Last post by patton on Today at 07:18:29 am »
Hi everyone,

Has anyone tried to make custom Mapbox maps into Cognos Dashboards or Reports? Is it possible?
Report Studio / Re: Issues with DQM cognos package
« Last post by MFGF on Today at 05:12:11 am »

This sounds like a possible product defect to me. Have you logged it with IBM support? What version and fix pack of Cognos 10 are you currently using?

Framework Manager / Re: Joins in Database or Logical layer?
« Last post by MFGF on Today at 05:07:21 am »
If I read you here, you use only 2 layers; database and logical/business. Right?

Yes. You can add a third layer comprising star schema grouping shortcuts if you wish - this might make selections for packages easier. You wouldn't do any true modelling in this layer, though.

It's also common to have a fourth layer if you are creating DMR regular dimensions and measure dimensions :)

Framework Manager / Re: Calculations in Presentation Layer
« Last post by MFGF on Today at 05:04:35 am »
Hello All,

We have 2 fact tables, 2 conformed and a non-conformed dimension. I have created two star schema groupings, first one with a fact and two dimensions while the other star schema is a fact and 3 dimensions (1 non-conformed).

Framework is a three layered approach ---> Import Layer (database tables)--->Intermediate Layer (..where I model my star schema) ---> Presentation Layer (..mere short-cut to my Intermediate Layer using create star schema grouping).

I have to create calculations within Framework Manager that spans multiple dimensions.

As an example, assuming my sales fact is a star schema with Product, Location and Time, I now have to create a calculation in FM as below

when Product='Prod1' and Location='Loc1' then 100
when Product='Prod12 and Location='Loc12' then 125


The intention is to have this calculation within FM so that it can be used across the reports.I dont think I can define this calculation in Intermediate Layer, the only place I could think of is creating a new query subject in my Presentation Layer.

Please let me know if there are any repercussions if I do this or is there a better way to handle this.

Appreciate your inputs..Thanks



Can you explain why you can't define this within your intermediate layer? That seems to be the most appropriate place for this. Wouldn't this just be a calculated measure in your fact query subject?

Reporting / Re: Can we Use Parameter Map in Prompt # Macro
« Last post by MFGF on Today at 05:02:17 am »
Thanks Lynn for your response!

Sorry I may not be clear. The measure is driven based on the Combination of 4 Prompts selection.

Lets Say-

Prompt 1 has Use Values - A,B,C,D
Prompt 2 has Use Values - W,X,Y,Z
Prompt 3 has Use Values - E,F,G,H
Prompt 4 has Use Values - I,J,K,L

1) if the user selects A, W, E, I in the above prompts [Measure 1] is shown
2) if the user selects B, W, E, I in the above prompts [Measure 2] is shown
3) if the user selects C, W, E, I in the above prompts [Measure 3] is shown
4) if the user selects D, W, E, I in the above prompts [Measure 4] is shown
5) if the user selects A, X, E, I in the above prompts [Measure 5] is shown
6)  if the user selects A, Y, E, I in the above prompts [Measure 6] is shown
 Until all the Possible Selections are completed.

As of now I am writing Case Statement in the Report, So I wanted use #Prompt# Macro to avoid the Case statement.



Wouldn't you just concatenate the prompt functions within your macro?

eg #$Your_Parameter_Map{prompt('Prompt1','token') + prompt('Prompt2','token') + prompt('Prompt3','token') + prompt('Prompt4','token')}#

Am I missing something?

Report Studio / Hidden info for sections?
« Last post by Invisi on Today at 04:36:11 am »
I created a report with a section header to create identical lists for different values of one field. I find this a more elegant solution than using a master-detail relation with the page. This works fine so far.

Now I add some rows from a different star using a union. When I switch the query for either the inner list or the section list, the report starts to behave differently, showing more rows, etc. This feels strange to me, since basically I just add more rows to the same dataset. Who knows what I am overlooking? Or is there some hidden or hard to find setting related to sections that has a relation to the query name?
Framework Manager / Re: Joins in Database or Logical layer?
« Last post by Invisi on Today at 04:29:50 am »
I don't follow? I'd have a database layer, and a logical/business layer. The database layer has the relationships. The logical/business layer has the calcs, filters, friendly names, friendly structures.


If I read you here, you use only 2 layers; database and logical/business. Right?
Pages: [1] 2 3 ... 10