Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


1.Can we create a cube in a Transformer from multiple
IQD's ?if so, how?
2.Also , explain some of the best practises used ,while
creating a cube in powerplay transformer.

Answers were Sorted based on User's Feedback



1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain so..

Answer / guest

yes we can create cube from multiple iqd's , we have to
first import the primary datasource which contains most of
the structural data item required for the cube creation,
and then other sources,by inserting the data source
separately.
Good practises:
1. we can incrementally update the cube.
2.check the cube status periodically
3.run the test cube with a small amount of data.eg., if you
have 1000 records , we can assign 300 records from each
data source and perform a sample test cube.
4.we can do partition, to improve the runtime performance.

Is This Answer Correct ?    2 Yes 0 No

1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain so..

Answer / vijaya yadav

yes we can create a cube with multiple IDQ's as data
sources,for this insert data source of tyye Impromptu Query
Definition in Transformer model.
afer creating a cube u can---
1)Partition a cube
2)Update a selected cube by batch file or by macro
3)Apply security to a cube
4)Compress a cube.
5)Publish that cube on Upfront.
6)Use that cube as DataSource in FM in Cognos Series 8

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Cognos Interview Questions

For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?

5 Answers   TCS,


What is metric store database?

0 Answers  


17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?

3 Answers   TCS,


What is Cardinality b/w Fact to Fact?

4 Answers   IBM,


What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance

1 Answers  


A list box contains 1000 records, while running the list, inside the header the content has to scroll down. Note the header should not go up?

1 Answers  


what are the components having in the report studio using interface eg:insertable objects pan,properties pan

1 Answers   HCL,


How will you migrate your reports to QA environment?

2 Answers   Satyam,


what is the difference between group span and level span

1 Answers   Satyam,


What is the advantage of using shortcuts?

0 Answers  


How to create a Ratio in Cognos Report studio Reports?

1 Answers   IBM,


1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question

2 Answers  


Categories