Search results for query: *

Hi I have a crosstab report.In this report i have rows as product line,product type and column as order year and measure as quantity. I want to pull the product line into column header(crosstab corner).i tried by adding block to crosstab corner and pulled the product line into block.But when i...

we need to change In cognos Impromptu. all the Tables Existing in the current Database. How we can call the Package in Cognos Impromptu

Hi, We are using Cognos Impromptu 7 version. Existing we have 2 Reports and they created 2 Packages for that reposts.they calling those packeges through Impromptu stored procedure.they are passing 4 parameters for each report.In each package we have main query(Package and 4 parameters) and List...

Hi our Client using Cognos Impromptu 7.0.554.14(version) Do the Client Require seperate License for Cognos Transformaer and power paly? Thanks Sai rao Chowdary

Hi We are trying to create a filter for finding the maximum of salary for dept name.We got the following error while we try to run report with this filter. the report columns are deptname,max_sal(filter from FM) Any one please suggest me in this regard. QE-DEF-0149 Incorrect query...

Hi Any One I have few doubts in cognos,any one could help me in this regard. 1.what are canned reports 2.what is a component in impromptu 3.how to create cascaded prompts 4.how to access database from impromptu report Thanks Sairaochowdary

Hi anyone I have few doubts in following areas.Any one could help me in this regard 1.what is meant by materialized view 2.can we import oracle packages into catalog. 3.what is meant by confirmed fact 4.do we have option of creating optional prompts in impromptu. Thanks Sairaochowdary

Hi Anybody 1.I have a report with data pulled from oracle database,is it possible to load data from sql server into same report. 2. different tables into catalog from different datasources(oracle& sql server) Thanks sairaochowdary

hi anyone I have few doubts.any one could clear my doubts 1.what is meant by monster dimension 2.difference between factless and fact tables 3.what is meant by divide by zero and 80/20 suppression. 4.what is meant by associate level in trasformer Thanks Sairao chowdary

Hi guys i have some doubts in datawarehousing. 1.can we use reporting tools with OLTP. 2.can we use OLTP instead of OLAP. 3.what is the limitation in indexing Thanks Sairaochowdary

Hi anybody i would like to know about sarogate key Thanks Sairaochowdary

Hi everybody I have very few doubts in below mentioned concepts.Anyone can solve my doubts. 1.can i have more than one fact table as data source to transformer. 2.is it possible to have different measures for different levels in single cube 3.is it necessary that impromptu be installed in the...

hi I think dataset is not supported in MR1 version.Me too facing same problem.I got data sometimes and sometimes i am seeing blank report with rows and columns thanks Sairaochowdary

Hi Anybody Could you please let me know ,is there any limitation on size of hotfile(Maximum size).I need to create a hotfile according to my requirement Thanks Sairaochowdary

Hi iam working on impromptu for developing on monthly sales analysis report.iam adding monthwise sales for certain products.after adding 3 months data it is giving the following error.it is adding 3 months data to the report.if i try to add fourth month it is giving following error. error-239...

Hi Any One Please let me know the report development from scratch to the hosting using cognos reportnet Thanks Sai rao

Hi I would like to know to which version reportnet belongs to Thanks Sai Rao

Hi I have an idea on cognos reportnet.Now i need some detailed information regarding reportnet.The information needed is noted below. 1.How do the data is taken into query designer and report studio. 2.Is it necessary to have catalog.If, so where do we point the catalog in query designer and...

Hi flex Please explain me the datailed procedure involved in refreshing the cube for every hour or day or monthly.it is most urgent Thanks sairao

Hi flex Thanks for your response.What actually i need is if i want to refresh the cube for every hour or day or week,what is the procedure involved in refreshing the cube as per requirement.i need detail steps involved Thanks Sai rao