Recent Posts

Pages: [1] 2 3 ... 10
1
COGNOS Transformer / How to Hide a Category for a Dimension
« Last post by Kiran Kandavalli on 15 Jan 2021 03:37:21 pm »
Team,

In the Source Report I created a Category Column and in that column I have expression as below

Case
Condition 1 then ('Primary')
Condition 2 then ('Secondary')
else ('N/A')
End

So when I publish the Cube this Dimension shows all these 3 values

Primary
Secondary
N/A

Is there a way that we can hide the N/A category and the Total should be based on Primary & Secondary.

Please suggest on this!

Thank you!
Kiran
2
Reporting / Dimensional reporting
« Last post by cognos05 on 15 Jan 2021 03:28:43 pm »
Hi , I have a base report where i pass my member unique name for the month selected .

In my drill through report i should have 2 columns , one the selected month sales and other column as sales of selected month -12 months

something like this


               Nov 2020   Nov 2019

Product1     100          50


I have the calculation for my dataitem in the column as

dataitem1 - Tuple([H0 Sales],[PrmMonth])

dataitem2 - Tuple([H0 Sales],lag([PrmMonth],12))

[PrmMonth] = #prompt('PrmMonth','mun','[YTD]')#


The problem i am having is I am not able to show the caption of columns as Nov 2020 and Nov 2019 .

It shows the column name as dataitem1 and dataitem2

I tried doing the report expression on the column name , and tried to use
caption(#prompt('PrmMonth','mun','[YTD]')#)
but this caption function will not work in report layout .

SO i directly tried to use substring([Query1].[PrmMonth],1,6)

but this will give me a blank value.

Any sugestions on how to achiee this in here with cubes.


Thanks,



3
Data Modules / Re: Creating Data Module from Data Package
« Last post by adam_mc on 15 Jan 2021 01:22:01 pm »
If you are looking to "store" a minimum amount of data created by some dynamic filtering, I suggest you look at Data Sets rather than Data Modules.
As previously stated, Data Modules do not store the data whereas a Data Set will allow you to store a subset of data that you can refresh on an as needed basis.

You can then build reports and dashboards over that Data Set.

Hope that helps,
Adam.
4
Data Modules / Re: Creating Data Module from Data Package
« Last post by bus_pass_man on 15 Jan 2021 12:39:58 pm »

A module does not store data; it is a query planning model.

You would need to have a better idea about what exactly you want to do.  That would help me suggest approaches to the matter.

Modules support relative time filters.   

You could create views from objects in the FM package and set up the relative time for whatever measures you want.


5
Active Reports / Re: cognos 11 chart connection - active report
« Last post by ddma on 15 Jan 2021 11:20:49 am »
Hi,

You didn't mention setting up a master/detail link between your data deck and Chart B? Did you miss out that step?

MF.

Yes, that was an issue. All works now. Thank you for your help!
6
Data Modules / Creating Data Module from Data Package
« Last post by Anandkittu on 15 Jan 2021 08:12:51 am »
Hello,

Am new to Cognos Analytics and am trying to create a data module by using an existing data package as the source. I want only the last one month of data in my data module so I want to use a dynamic date filter to fetch data from the package. Please provide steps on how to achieve this.

Regards
Anand
7
Hi,

Any inputs on this would be helpful.

Thanks,
WL

I would try setting up your IIS virtual directories again as a next step. Given you are doing single signon, things may have got messed up with the domain change.

MF.
8
Active Reports / Re: cognos 11 chart connection - active report
« Last post by MFGF on 15 Jan 2021 07:32:24 am »

Thank you MFGF, very helpful!
However, I believe Im missing something, because its not working for me. I tried to recreate everything you wrote for chart functionality, but my second pie chart is not changing, can you please have a look at my steps and suggest what I did wrong?


1.  Create table based on 2 columns.
2. In 1 column I add Pie Chart A (country/revenue) based on query 1 (company, country, revenue).
3. In 2 column I add Data Deck 1. Deck Item = Country. In Data Deck I add Pie Chart B (company/revenue) based on query 2 (company, country, revenue).
4. For chart A I add connection. Source Control -> Chart A. Data Item = Country. Behaviour = Select. Target Control: Data Deck 1. Data Item = Country.

But when I ran report Pie Chart B is not changing. When I press on segments of Pie Chart A, then Pie Chart B sometimes blinks but values are not changing...

Can you please suggest what Im doing wrong? Thanks

Hi,

You didn't mention setting up a master/detail link between your data deck and Chart B? Did you miss out that step?

MF.
9
Active Reports / Re: cognos 11 chart connection - active report
« Last post by ddma on 15 Jan 2021 06:14:19 am »
Hi,

I assume you're using Cognos 10 based on where you posted this - in the Cognos 10 Active Reports board. The first question (and possibly the most important) is whether you are using charts or visualizations. There is a big difference in an active report. Charts (from the AVS charting engine) are rendered server-side, and appear in your report output as png images. They cannot be interactively re-rendered within the output of an active report because the AVS charting engine isn't included in the report output.

To get charts to appear to change, which is (I think) what you are trying to achieve here, you need to use data decks. Your chart sits inside a data deck and is master-detailed to the query of the data deck, based on the value you want to "filter" on. So if you have a pie chart showing revenue by Company, and you want the chart to change for different Country selections, the query for that pie chart would also need to contain the Country item. It would sit within a data deck based on Country, and it would have a master/detail relationship with the data deck based on Country. When the report is rendered, the data deck would contain a different card for each Country, each showing a pie chart of Revenue by Company for that country. You could also add a Default Card to the data deck, containing a pie chart of Revenue by Company for all countries.
Your control would then set a Country variable driving the data deck using SELECT behaviour. When no Country has been selected, the Default Card would be displayed, showing the chart of Revenue by Company for all countries. When a Country is selected, the Data Deck would flip to the card for that country, showing the chart of Revenue by Company for that country.

If you are using visualizations rather than charts, it's a different story. The RAVE visualization engine is included within the Active Report output, and this means the visualizations can be interactively re-rendered within the output. This means you don't need to use data decks, and you can filter the visualizations using one or more items.

When using visualizations, you will see an "Extra Items" slot you can drag data items into. This allows you to bring in items not being displayed so you can filter on them. In this case, the pie visualization for Revenue by Company would have Country in the Extra Items slot. Your control would then set a Country variable which uses the FILTER behaviour on the visualization.

Hope that helps!

MF.


Thank you MFGF, very helpful!
However, I believe Im missing something, because its not working for me. I tried to recreate everything you wrote for chart functionality, but my second pie chart is not changing, can you please have a look at my steps and suggest what I did wrong?


1.  Create table based on 2 columns.
2. In 1 column I add Pie Chart A (country/revenue) based on query 1 (company, country, revenue).
3. In 2 column I add Data Deck 1. Deck Item = Country. In Data Deck I add Pie Chart B (company/revenue) based on query 2 (company, country, revenue).
4. For chart A I add connection. Source Control -> Chart A. Data Item = Country. Behaviour = Select. Target Control: Data Deck 1. Data Item = Country.

But when I ran report Pie Chart B is not changing. When I press on segments of Pie Chart A, then Pie Chart B sometimes blinks but values are not changing...

Can you please suggest what Im doing wrong? Thanks
10
Reporting / Re: Query Results as Default Value for Text Prompt
« Last post by dougp on 14 Jan 2021 07:01:27 pm »
If you use the "edit box" GUI for the date prompt, they can still type.  It will accept most valid date format strings.
Pages: [1] 2 3 ... 10