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...

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...

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...

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, 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, 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...

Hello, I need to create a report that looks like a crossTab (right side) attached to a list (left side). The report would have 9 columns on the left side and then 7 columns with a value of a metric on each line. Is that possible ? Thanks !

Hi, 1- I create a list of 4 columns using the topCount function in one of the columns. It works fine. 2- The first column contains a calculation as follows and displays me the description of the products: topCount([Level];10;[Metric]) 3- The idea is to have the top 10 products based on...

Hi, I need to HIDE one column from a list. If i simply CUT the column i no longer see it on my list BUT i loose the functionality of that function even if it is still on my query. So it seems that the column needs to be PART of my column so that he functionality works. I know how to hide a...

Hi to all, - We have a simple list report with only 4 columns - One of the columns (the last one from the left) is named "Rank" and is based on one of the columns (measure) - The code inside this column is as follows: rank([Number of Pieces]) - we are using Report Studio 8.4 against a package...

Hi, Question#1: I need to have a title on the corner of the cross tab, is that possible ? I have my Clients displayed on the lines of my Cross Tab. I have 3 measures displayed on the lines of my Cross Tab. I have months on the columns. Question#2: Still on the same report, we need to break...

Hi, We use Report Studio 8.3 We need to format a column of type "character" in our list. The column has 5 to 7 characters. We want to format the column in order to ADD "zeros" when less than 7 characters. For example a column with the value: 12345 would become 0012345 Is this...

Hello, Can someone please give me a brief resume of the advantages and disadvantages of Query and Analysis Studio ? Thanks in advance !