Recent Posts

Pages: [1] 2 3 ... 10
1
Cognos will generate the SQL/MDX based on the fields being used in the data container. In this case simply bringing the measure into the query pane isn't sufficient, as it's ignored during SQL generation.

Two things to do.

1. Create a detail filter in the prompt query. Something like:
Code: [Select]
[Measure] is not null    When the SQL is created, it will include the detail filter in the where clause.
2. Add the measure to the properties of the prompt. This forces Cognos to include the measure when generating the SQL, and will ensure the JOIN is created.
2
Hello,
  I have a value prompt for an year which gets pulled from a dimension table. The underlying dim table has values from 2000 till 2020. In the fact, I have data only from 2005 till 2017. Without using filter (in prompt query), how do I ensure that my prompt will retrieve values based on the dim-fact join?

  I cannot make prompt from fact table as there is no year in the presentation area of fact. 
I also tried adding a fact column to the prompt query. But it is not performing the join when pulling the value for the prompt.

3
Reporting / Comination chart issue in cognos11
« Last post by sunny bachan prasad on Today at 03:20:48 am »
Hi,
We have recently migrated to cognos 11 and facing issuse with combination chart. We have a report which consist of combination chart and it is running fine in  Cognos 10. But same report in cognos 11 is throwing erorr as "INTERNAL QUERY SERVICE ERROR HAS OCCURRED". In combination chart we are using three data item in series primary axis in which 1 value is bar graph and other two are for  line graph. Report is running fine when i am uisng 1 data item for bar and line but when i am using 1 data item for bar and other two for line graph then above error is coming. I checked query it is working fine and able to generate tabular data as well. Can anyone share his/her experience on this?

Thanks in Advance.
4
Reporting / Re: Drill through report
« Last post by oscarca on Today at 02:33:19 am »
Instead of trying to drill 1 <-> 2, create a thrid report (a copy of the first 1) and drill 1 -> 2 -> 1
5
Report Studio / Re: Business hours in a time interval data item
« Last post by DaniEU on Today at 01:43:58 am »
Hi BigChris,

I have an answer from another site that appears to be a simple solution.
I will create a new table with dates and values, where every day we have a value of work hours, where weekends, holly days, and so on will have a value of zero. Then just sum the dates between, and subtracting the first hours of the first day, and last hours of last day.
To create this table, I'm creating a Linux script.

Thanks for your help!
6
Report Studio / Re: Business hours in a time interval data item
« Last post by BigChris on Today at 01:02:01 am »
Hi Daniel,

It's going to be a mighty big calculation, unless someone has something that will already do it. Essentially, you're going to have to work out how many weeks there are between today and the end date so that you can work out the weekends, but even that is difficult since you're working on Sundays. I think there might be an options to say when the week starts (which would help you out with that) but I don't know for sure. Basically, there's nothing built in - you're going to have to work out all the bits between today and the target date then add them all up...it's not going to be easy.
7
Administration and Security / Re: Cognos Analytics 11.0.12 is here
« Last post by Lynn on 14 Jul 2018 12:20:14 pm »
Over 10 days and still no fix list:  http://www-01.ibm.com/support/docview.wss?uid=swg27047208
Since IBM won't tell us, does anybody here know why this release exists?

And I love the 11.0.11 fix list that has one fix with no hyperlink listed above the table.  I'm sure IBM is happy to have us all (not) on the payroll to perform QA.

I suspect the features added in 11.0.12 were included to make them available as part of the coming 11.0.13 LTS release.

https://www.ibm.com/communities/analytics/cognos-analytics-blog/ibm-cognos-analytics-long-term-support-release-lts/
8
Report Studio / Business hours in a time interval data item
« Last post by DaniEU on 14 Jul 2018 08:46:40 am »
Hi,
I had a request to display a number of hours till a target time.
For instance we have a target date/time (let's say next Tuesday at 11AM) and the report should display time interval between NOW and this target date/time, but business hours only, so week end off and non working hours also off.
I'm using Cognos 10.2.2 against salesforce.com.

I can calculate number of hours but how can I remove the non working hours?
Working hours are Sunday-Thursday 08:00 - 17:00, Friday 08:00 - 12:00.

Thanks in advance,

Daniel
9
Report Studio / Re: Find a string between two symbols
« Last post by sdf on 13 Jul 2018 08:09:27 pm »
are you always gonna get the 3rd string?

is substring([zoneName],3,0)

an option?
10
Administration and Security / Re: Cognos Analytics 11.0.12 is here
« Last post by dougp on 13 Jul 2018 06:17:26 pm »
Over 10 days and still no fix list:  http://www-01.ibm.com/support/docview.wss?uid=swg27047208
Since IBM won't tell us, does anybody here know why this release exists?

And I love the 11.0.11 fix list that has one fix with no hyperlink listed above the table.  I'm sure IBM is happy to have us all (not) on the payroll to perform QA.
Pages: [1] 2 3 ... 10

       
Twittear