Search results for query: *

Hi, Anyone has ever had issues with Cognos 10.2.1 using a Mac ? regards !

Hi there, (Please take a look at the attached print screen) We have this FactTableA linkked to DimTableB which in turn is linked to DimTableC We added a new join between DimTableC and FactTableA. Are we dealing with a "loop" join ? Do we simply need to create an Alias Shortcut and how and of...

Hello, Is there a way of import a file (Excel) for example into our Cognos model in FrameWork Manager to map the translation terms from Italian to English so that we do not need to type them many and also to avoid typing errors. The goal is to ask the question end user to provides us an excel...

Hi, Using Framework manager v10.1.1 and we have 3 name spaces as suggested by forums and documentation: DataBase View Business View Presentation View And under our "Business View" name space we have 2 other business views name spaces as follows: BusinessView-US +QuerySubject1 +QuerySubject2...

Is this even possible anyone [sad]

Hi to all, - We have 2 queries - Query#1 has data items and metrics to display the GREAT TOTAL with no user prompt selection - Query#2 has data items and metrics to display totals based on what the user selected on the prompt page QUERY#1 -- Great Total -- [Total Sales] (NO user prompt...

Hi, We have developped template reports so that when users select "new" they have a choice of predefined reports built by us. This works fine BUT WHEN we switch to EXPRESS MODE (VIEW > AUTHORING MODE > EXPRESS) there are no template reports available ??? We are using Report Studio 8.4...

Hi to all, Is there anyone able to let me know what are the BAD parts of Report Studio 8.4 ? I know many advantages but can anyone please let me know of some DISADVANTAGES of Report Studio 8.4 ? I need to be able to sale the good and (unfortunatley) the bad points ... Thanks in advance for...

Hello to all, I found a way to do my report. I am know using a crossTab instead of a list ... In this case the report runs faster. No need to use tuple functions. I found out that often the crossTabs reports runs faster than same list report. Thanks anyhow!

Hello Ties, 1- In deed, i found out that i need to delete all 4 graphics from my report to gain performance. I have decided to provide an option to the users that lets' them the choice between "Display graphics" or "Don't display graphics". I use conditional blocks for this and a block...

Hi decode360, This ALSO what i received on another forum when i prompted my question: ======================================= Reply from winson on 8/3/2009 11:25 AM Enable Session Caching In Report Studio, Query Studio, and Cognos Viewer the results for previous requests to the database are...

Hi, I have this report that: - Is made out of 2 queries. - I have created a second query called "Summary" based on the first query named "Detail" - The report ss made out of 2 pages. First page has a simple cross tab + 3 "Combination Charts" based on the query "Summary". Second page, has...

Thanks. I found out on another cognos forum that i can simply se to "NO" the query "Use Local Cache" property on my report. This seems to be working for me. See ya !

Hi, I run this report and takes me 1 minute of processing time. I re-Tun the same report a second time and now it takes only 5 seconds ... I heard it is because of the cache. I need to make tests on this report in order to reduce the report processing time from 1 min to half that time if...

Hello, 1- We use a bw cube in our package to develop our Report Studio reports in version 8.4 2- I run this report that runs in just 5 seconds. 3- I rerun the same report seconds later (with same parameter values and all) and it takes 1 minute to run. 4- I rerun the same report 2 minutes later...

Hi blom0344, 1- No that is a key that is unique. 2- I was creating the calculation i needed in a data item Then i selected my list object and then create a footer. Does this answers your question "How do you propose to add those to the footer?" 3- Finally i found another way to calculate...

Hi, I have a data item in my query that has the following expression: count(distinct [Material Real Key] for [Store Real Key]) I validate the report and NO error message. I have a simple LIST with only 2 columns: [Store Real Key] and [Product Key] I then create a footer by choosing "Store...

Hello, I am using a report with one simple list of 7 metrics + 2 calculated columns. I run the report and it executes with no problem in 2 seconds. I ADD another calculated column at the end of my list with the following code: tuple([METRIC];[Day1]) I run the report and it takes about 5...

Hello to all, Just for your information: This is not possible for our team as for many functions are unable to us and have exclamation marks ... this includes character_length, cast, extract etc ... I managed to use the key column instead and i am now having what expected. Good day to all !

Hello, 1- I have this crossTab with lines and columns and 1 implicit measure on the corner of the crossTab. 2- I need to have TOTALS of all the columns of my crossTab 3- I tried by adding a crossTab space on the last line of my crossTab and it kind of works but not completely. Only the columns...