Recent Posts

Pages: [1] 2 3 ... 10
1
Cognos Administration / Unable to find My Folder
« Last post by Naresh on Today at 03:59:00 am »
Hi All,

When i am trying to Publish a FM Package / Import or Export in Cognos Connections page, I am unable to see "My Folders" Option.

I am able to see the only below options
Public Folders
Directory
Library
2
Out of curiosity, what do you expect to happen if a user selects a higher level? Do you want it to filter by that?

For example, if a user selected:
United States
Canada/Ontario
England/West Midlands/Birmingham

I would expect the filter to be:
    [country] = 'United States'
or [state] = 'Ontario'
or [city] = 'Birmingham'

Is this scenario likely?

If the user only selects members in the department level, you could do something like:
Code: [Select]
[DepartmentID] in (#
join(',',
substitute('\]','',
substitute(
  '\[GENERAL_EXPENSES\]\.\[Entities\]\.\[Entities\]->:\[DO\]\.\[Entities\]\.\[Overall\]\.\[Departmental View\]\.\[HO\]\.\[EXECUTIVE_HO\]\.\[Finance Summary\]\.\[DIAA Summary\]\.\[Non-Regional Summary\]\.\['
  ,''
  ,split(';',
  promptmany('department','mun')
)))
)
#)
3
Reporting / Execute Report from HTML Item
« Last post by br54016 on 21 Nov 2017 07:14:15 pm »
I am trying to execute a report from a custom home page using an HTML item.  The goal is to have the report show up in the dropdown in the center of the interface (just like they do when you run from the folders).

Here are the steps that I assume would work:

1. Run report from menu
2. Copy URL from browser
3. Paste URL into HTML Item script

<div class="tooltip"><a href="paste url here" >
[/url]</div>

When the link is clicked the report executes but I end up with two sets of menus (two run buttons, two sets of Quick Links, two Help menus), one inside the other.

Thanks,
Brad
4
Report Studio / Re: Passing Tree Prompt Parameter Value to Relational Query
« Last post by MB_DIAA on 21 Nov 2017 03:33:57 pm »
I've done something similar.

Can you post an example of the MUN generated from the prompt? You can use macro functions to strip the mun to generate the filter, but the way it's written depends heavily on how the dimension is defined.

This is the MUN of the lowest level in our dimension:

[GENERAL_EXPENSES].[Entities].[Entities]->:[DO].[Entities].[Overall].[Departmental View].[HO].[EXECUTIVE_HO].[Finance Summary].[DIAA Summary].[Non-Regional Summary].[1001223]

This is an essbase cube and the structure is less than ideal to say the least. Our relational data source has that same department ID (1001223) as a column.
5
I've done something similar.

Can you post an example of the MUN generated from the prompt? You can use macro functions to strip the mun to generate the filter, but the way it's written depends heavily on how the dimension is defined.
6
Report Studio / Passing Tree Prompt Parameter Value to Relational Query
« Last post by MB_DIAA on 21 Nov 2017 01:50:45 pm »
Hello,

I could use some help trying to pass a tree prompt parameter value to a relational query all in the same report.

The report was originally built using an OLAP data source. At a high level, the OLAP data source contains departments and their annual expenses. One of the tree prompts on the report allows the end users to select multiple departments by navigating through the "Department" dimension in the OLAP data source.

What we would like to do is take the department the end user selects on the tree prompt, and pass it through to another query subject which will hit a db2 table and pull back a list of all the employees in that department. This would also need to support multi select so if an end user selects multiple departments we would want both department ID's passed through to the relational query subject.

For example:

User runs report and selects the following from the departments tree prompt:

Departments -> HQ Office -> 1001 - Finance
and
Departments -> HQ Office -> 1002 - Sales

as parameter "Department".

This would generate a report which displays the yearly expenses for both the Finance & Sales departments.

What we are looking to add is the following:

A basic list sourced via a relational query hitting our db2 table which stores the department and employees in each department.

In the relational query we would want the filter to be "RELATIONAL_TABLE.DEPARTMENT in ('1001 - Finance' , '1002 - Sales') based on the selections made on the tree prompt.

Does anyone have any experience with this?

7
Reporting / Re: 11.0.8 Date functions broken?
« Last post by Jeff H. on 21 Nov 2017 11:48:22 am »
Thanks! I haven't been doing much FM modelling/report writing lately and forgot which functions work in query subjects vs. report.

We ran into a problem in a report existing report where the report expression was:

_last_of_month(string2timestamp(ParamValue('pDateRange')))

we had to modify it to:

_last_of_month(date2timestamp(string2date(ParamValue('pDateRange'))))


From what we are seeing the string2timestamp is now not accepting the ParamValue because it's actually a date. It appears the function is now strongly typed so it must be a string for the string2timestamp to work. It would be nice if _last_of_month didn't expect a timestamp and could use a date instead.
8
The installation upgrades blows away any custom .dlls that you have put into the bin64 folder. For SQL Server I have to remember to re-add sqljdbc_auth.dll to that folder.
9
Administration and Security / Re: Upgrade issue from 11.0.6 to 11.0.7
« Last post by Jeff H. on 21 Nov 2017 11:36:10 am »
Your crypto keys and cogstartup might need to be recreated or hopefully copied to your configuration folder from a backup. The over the top install wipes out the configuration files (at least it did for me on 11.0.6 -> 11.0.7) so that might be causing your issues as the Cognos service might not be connecting to your content store.
10
The solution is quite simple.  Create a report view of Active Report.  then go to the administration > themes/extensions > view home area and select the report view instead of the original active report.
Pages: [1] 2 3 ... 10

       
Twittear