Recent Posts

Pages: [1] 2 3 ... 10
1
General Discussion & Gossip / Re: Cognos Events - feedback request
« Last post by cognostechie on Today at 07:16:20 pm »
Though not a survey but from what I have seen, 3 companies I worked with in the past are moving away from Cognos. There are also fewer jobs for Cognos and companies who are buying new BI licenses tend to prefer Power BI and Tableau. Anyone else wants to chip in here?

 
2
Framework Manager / Re: Multiple Data Sources (Design Question)
« Last post by cognostechie on Today at 05:35:12 pm »
This is a very common scenario and one of the reasons for failure of a BI implementation in many companies. The managers/directors in these cases are always found to be from another background with no knowledge of BI. For them, a car is a car and one car cannot be different than the other so if an engine is required then 'all we got to do is put any engine in it and it should just work'. 5 yrs down the road and with few million dollars burnt and 10 more developers hired to support poorly performing reports, the tool would be blamed for not performing proper and a new tool will replace Cognos with another initiative of burning few more million dollars !

The good part about this is that it helps build the economy as more people get jobs, more consulting companies make money etc. According to me, the problem always starts from the top. It is actually the fault of somebody higher up who appointed somebody as the manager for this initiative without determining if that manager has any knowledge of the subject. I have seen musicians getting appointed as the Director of Data Warehousing and Mechanical Engineers getting appointed as BI Managers. Per some people at the top, for a technical role, they have to make sure that the guy is an engineer regardless of what kind of engineer he is. Per some other C level executives, the ability to communicate is more important than a qualification of the subject ! 
3
I haven't used Transformer recently but I remember there are more options (in addition to Source and Label) in every level like Description, Category Count etc which would be available in RS.
4
sorry , you were correct , i changed the expression to except(Descendants(LatamNorth],Country),[Mexico]).

This works with out error .

But i want this as 1 member shown in propmt ,along with other countries, now its showing all the countries except mexico . I want this to be grouped as one member and shown as a value in prompt.

Thanks
5
Administration and Security / IIS rewrite for dispatchers
« Last post by sdf on Today at 12:51:37 pm »
What is the correct rewrite setup for  :

e.g 1 Gateway 2 Dispatchers?
      Two URL Rewrite?

e.g 2 Gateway 2 Dispatchers?
      Gateway 1 rewrite to Disp1, Gateway 2 rewrite to Disp2.

I am exploring different approaches.
6
Hi ,

I have a countries dimension and it has members like

NAM,LATAM-North and LATAM South and countries under each .

Now I have a query which shows all countries under LATAM NORTH and LATAM South .

Descendants(set(LatamNorth,Latam South),Countries).


Now user requires a custom member to also be shown in prompt .

That is LATAM North - Mexico (Exclude Mexico from LATAM North)


So I wrote a custom item where
Except(LatamaNorth , Mexico )

And then tried to do a union to the  query that feeds the prompt

Uninon(Descendants(set(LatamNorth,Latam South),Countries),Except(LatamaNorth , Mexico ) )


But I get a member to value coercion error .

Can anyone suggest me how to handle this .

Hi,

Your expression doesn't seem to make logical sense - at least not to me

If I'm understanding, you have three members on one level - [NAM], [LATAM-North] and [LATAM South]
The members at Countries level below this are your Country members?

If that is true, what are you trying to achieve with the part of your expression that is Except(LatamaNorth , Mexico ). These are two individual members at different levels? Are you trying to get all the Country members below [LATAM-North] other than the [Mexico] member? If so, wouldn't the expression for this be

Except(descendants([LATAM-North], [Countries]), [Mexico])

Can you elaborate?

MF.
7
Reporting / Re: Hyperlink in Cognos 11 Analytics Dashboard
« Last post by Kiran Kandavalli on Today at 11:46:17 am »
Yes, will do. Thanks for your response!
8
Reporting / Re: Hyperlink in Cognos 11 Analytics Dashboard
« Last post by MFGF on Today at 11:40:40 am »
Hi,

Thanks for your reply!

I am looking to place a Text (Hyperlink) in the Dashboard when I click on the text / Hyperlink it should connect to another Dashboard.

Thanks!
Kiran

Sorry, but you're not able to do this in a dashboard. Create a report instead and add hyperlinks to this.

Cheers!

MF.
9
Hi ,

I have a countries dimension and it has members like

NAM,LATAM-North and LATAM South and countries under each .

Now I have a query which shows all countries under LATAM NORTH and LATAM South .

Descendants(set(LatamNorth,Latam South),Countries).


Now user requires a custom member to also be shown in prompt .

That is LATAM North - Mexico (Exclude Mexico from LATAM North)


So I wrote a custom item where
Except(LatamaNorth , Mexico )

And then tried to do a union to the  query that feeds the prompt

Uninon(Descendants(set(LatamNorth,Latam South),Countries),Except(LatamaNorth , Mexico ) )


But I get a member to value coercion error .

Can anyone suggest me how to handle this .
10
Reporting / Re: Hyperlink in Cognos 11 Analytics Dashboard
« Last post by Kiran Kandavalli on Today at 11:01:57 am »
Hi,

Thanks for your reply!

I am looking to place a Text (Hyperlink) in the Dashboard when I click on the text / Hyperlink it should connect to another Dashboard.

Thanks!
Kiran
Pages: [1] 2 3 ... 10

       
Twittear