Question 1. What Is Model And Say About Process How To Create Model And How To Test Model?
Model in PowerPlay Transformer is combination of five windows- Dimension Map,Data Source, Measures,Power cube,Sign On. Models specify the data assets after which defining the scale, stages,and measures.They may additionally contain dimension views, consumer training, user class perspectives, and different authentication-associated statistics. The facts for a model is saved in a model record, with the extension .Pyi (binary, way platform depentent) or .Mdl (textual content,platform independent).
Question 2. Explain How To Create Powerplay Reports?
To create a powerplay file
You need to create a IQD report from impromptu by saving IMR record as IQD.
Use Frame Work manager model and externalise the question challenge you need to apply inpowerplay transformer and powerplay.
When you have got the IQD record published to a vicinity including UNC.
Go to powerplay transformer version and select new.
Microstrategy Interview Questions
Question 3. What Are Products Of Cognos?
Cognos 6.6 7.0,7.Three(PowerPlay, Impromptu)--ReportNet1.0,1.1mr1, 1.1mr22---ReportNet 8.Zero(cutting-edge)IWR is locate with the aid of Impromptu to put up reports, PPES is used by PP, Cognos Connection is used by repornet. There are many other equipment but those are the main.
Question four. What Are Versions Of Cognos From Starting Release To Latest In The Market?
EP7 collection is the oldest cognos series.
Cognos file net is the next series.
Cognos eight.3 is the today's model.
But most of the organizations use cognos 8.1.
Question 5. What Is Cognos Visualizer And Cognos Scripting?
Visualizer is a illustration of facts cubes in a dashboard format. We can drill through to the floor stage of a hierarchy as like in energy play document however can not upload or remove fields dynamically.
Cognos script editor : We can write cognos macros or packages in this tool and can great track or method some execution.
IBM DB2 Interview Questions
Question 6. What Are The Limitations Of Cognos Reportnet? What Are The Enhancements In Reportnet ?
PURELY WEB BASED REPORTING TOOL
WE CAN CREATE MULTILINGUAL REPORTS
IT CAN SUPPORT ANY TYPE OF OPERATING SYSTEM & DATA BASE
WE CAN CREATE SINGLE MODEL IN FRAMEWORK MANAGER COMING FROM MULTIPLE DATA SOURCES
WE CAN'T DRILL DOWN AND DRILL UP
IT CAN'T SUPPORT MULTI DIMENSIONAL ANALYSIS
Question 7. What Is The Difference Between Group And Association?
Group: used to cast off replica values inside the report.
Association: used with grouped item that presentations information handiest while the values are modified.
IBM Cognos Tutorial Data Warehousing Interview Questions
Question 8. How Do Add Dynamic Titles In Pp?
PowerplayFrom format menu-->name, header & footer-->name-->insert report filename.
Question nine. What Are The Ways To Import Data Into Catalong?
One thru Database alternative different one although hotfile choice.
SQL Interview Questions
Question 10. How Can I Test Reports In Cagnos?
In cognos record internet by means of the validate document option a file may be tested. If there can be any error, it's going to specify the error, until it will provide message -'record specification is legitimate'.
After developing the report we will connect to the oracle and we can write the sq. Query and we are able to compare this 2 reports .
IBM DB2 Tutorial
Question 11. How Can I Schedule Reports In Cognos?
By the usage of Cognos Schedular, you possibly can schedule the running reports in Impromptu to execute and save it in favored format.
By the usage of Cognos MACRO script language the reports can be performed and dispensed to recipients via the usage of mail programs.
Compiled Cognos MACROs may be scheduled the use of Cognos Schedular.
IBM Cloud Computing Infrastructure Architect V1 Interview Questions
Question 12. How Can Create Users And Permissions In Cognos?
impromptu menu go to Catlog->User profiles -> userclass tab -> click on on Creator ->you could provide there folder access,table get right of entry to,filters,Governor etc.
You can create users by using the use of USERS PROFILE option..And you can provide permissions the use of ROLE IN C8 and GOVERNERS in C7.
Microstrategy Interview Questions
Question thirteen. What You Mean By Drill Across And What Is The Difference Between Drill Through, Drill Across?
Drill throughout means when you are transferring from one document to another record like country in one record and States in some other Report whereas if the record is the use of equal record from shifting from us of a to nation. In different whilst you are transferring info stage if you are the usage of the specific document it's far drill across and if you are using equal file it is drill thru.
Data Warehousing Tutorial
Question 14. What Is Loop In Frameworkmanager?
Loop: loop is a closed course (relation) that exists amongst 3 (or) greater tables. For instance, if we have '3' tables T1, T2, T3 then, a loop exists amongst those tables most effective whilst we create joins within the following style:
Loop: T1 ---> T2 ---> T3 ---> T1
To clear up the above trouble, we have to create a shortcut (or) Alias to the Table T1.
No Loop: T1 ---> T2 ---> T3 ---> Alias (or) Shortcut of T1
Question 15. How Create Measures And Demensions?
You can create measure after you import all of the information into the records supply.You can create measures and dimensions via draging the specified source from datasource into size map and degree tab.(want to find scope of measures for all the dimensions)
Framework7 Interview Questions
Question 16. What Is Meant By Alternate Drill Down With Ex?
Alternate drill down path way there might be two route to decide. For instance- We could have time size now the customer requirement is that they want sort of year -one is calender year(Jan-Dec) and some other is fiscal 12 months(Apr-Mar).
Question 17. What Is The Difference Between Enterprise Data Warehouse And Data Warehouse?
Big Organizations have a whole lot of various sources of records.There might be a dataware residence completely for transport and others for records associated with the venture the organization runs.In such case the complete organisation's(company's) facts warehouse is a large combination of all and is thought the Enterprise statistics Warehouse(EDW).
IBM BPM Interview Questions
Question 18. How You Drill From Powerplay To Impromptu? Explain All Steps?
build the cube
right click on the dice and open homes
visit drill via tab and select your document from that browse choice
IBM DB2 Interview Questions
Question 19. Give Me Any Example Of Semi And Non Additive Measures?
Semi-Additive: Semi-additive facts are information that may be summed up for a number of the size in the fact table, but now not the others.
Non-Additive: Non-additive records are statistics that can not be summed up for any of the size present inside the fact table. Current Balance and Profit Margin are the information.Current Balance is a semi-additive fact, because it makes feel to add them up for all money owed , however it does now not make experience to feature them up through time (adding up all cutting-edge balances for a given account for every day of the month does now not supply us any useful statistics). Profit Margin is a non-additive reality, for it does not make sense to feature them up for the account stage or the day stage.
Question 20. What Is Drill Down And Slicing And Dicing Whats The Difference Between Them?
Drilling lets you quickly circulate from one level of detail to some other to explore exceptional elements of your commercial enterprise.
Drilling down moves you down in the hierarchy.
Drilling up actions you up in the hierarchy.
Slicing and Dicing While you can drill to examine information at any degree, you could slice and dice to choose the precise statistics you want for your report.
IBM Cognos TM1 Interview Questions
Question 21. What Is The Difference Between A Cascading Report And Drillthru Report?Why Do We Go For Drill Thru Report?
Cascading file works based on the condition however drill thru work primarily based at the information item what we pick out as a drill through options.
Question 22. What Junk Dimension Contains?
it carries the miscellaneous attributes which include flags , which does belong to the main dimension table.
For eg; In a income order fact desk ,a few informations like, internet-order , whether or not this is a on-line order or now not new_cust-Is this individual a new purchaser , verification- whether or not the order has been tested.
Question 23. What Is Catalog And Types Of Catalogs In Cagnos And Which Is Better?
A catalog is a document containing the information (Database tables) that Impromptu customers need to create reports.
shared catalog is better.
Cognos ReportNet (CRN) Interview Questions
Question 24. What Is Meant By Junk Dimension?
The junk measurement is clearly a shape that provides a handy region to keep the junk attributes.
Data Warehousing Interview Questions
Question 25. Suppose You Run A Report With Empty Data, How Will You Inform The End User That It Has No Data While Running The Report In Report Studio? Is It Possible, If So How?
Add a listing footer and a text messsage inside "No Data". Create a boolean conditional variable "Test" with code "rownum()>zero". Select the entire list footer and set Style Variable, if Yes, Box Type of the List footer need to be set to "none".
Question 26. What Is The Difference B/w Macros And Prompt?
Macro-A macro is a set of commands that may run programs.
Example : A macro can open your catalog,select a document(say for example) convert that to some other layout and export it to any particular vicinity,supplied the code (Program)is such.
Prompt-A spark off specifies the way in which statistics within the reports are to be displayed.
A Prompt may be described at the catalog level both or all through document era.
Structured Query Report (SQR) Interview Questions
Question 27. What Is Cognos Powerhouse And What Is It Used For?
Cognos Powerhouse is High-Productivity Application Development Solutions equips you with excessive-productivity improvement environments for developing your statistics-driven commercial enterprise solutions quicker,whether or not for Web-based totally, customer/server, or traditional terminal-based totally get entry to. PowerHouse has gained a global recognition for productiveness, reliability, overall performance, and versatility.
SQL Interview Questions
Question 28. How Can We Create A Dynamic Column Name In Cognos?
Select Properties, and then click the Headers/Footers tab.
Question 29. What Is Transformer?
Transformer is used for constructing the Cubes (Multidimensional Structure used for OLAP processing).
IBM DataPower Interview Questions
Question 30. What Is The Difference Between Filter And Condition?
A Filter is a limit that reduces the quantity of facts displayed within the document.
The report filters are non-reusable and specific to the file.
earlier than aggregation: non-aggregated facts are filtered(details report)
after aggregation: summary statistics are filtered
Question 31. What Is The Security Module Used In Cognos?
The protection module used in cognos is cognos get right of entry to manager.
Question 32. What Is Report Burn And Where It Occurs?
Report can be divided into exceptional components and sending these distinctive parts of file to exceptional customers. It occurs in cognos connection.
Question 33. What Is Difference Between Drill Through And Drill Down?
drill thru permits you to navigate from precis to special statistics.
Drill down also similar form of issue,as an instance will do drill down on year if we drill down in this the subsequent degree will come approach year contains quaters, it incorporates
months contains weeks,
week carries days.
So,we are able to view all of the degrees thru drill down.
IBM Cloud Computing Infrastructure Architect V1 Interview Questions
Question 34. How Can I Change Reports To Another Package?
Open that report and shop as that reportSelect public folder and then pick out package deal in which package you need to save then shop it.
Question 35. How To Create Users And Permissions In Cognos?
Users and Permissions may be given in Access manager - Administration.
Individual users can be created the use of their names or their Ids (if any) in Access manager and then accept permissions.
This tool is loaded whilst you installation Cognos 7.X for your machine.
In content material supervisor--we've got one factor called cognos system supervisor, the usage of method supervisor we can combine with third birthday party gear like LDAP or NTLM. We cannot create customers in reportnet without delay, in actual time we can use LDAP.
Question 36. What Is The Difference Between Macros And Prompt?
Macro is about of instructions to run file.
Prompt is much like a conversation field which will ask person to pick out/enter the data what he desires.
Framework7 Interview Questions
Question 37. What Is Query Subject?
A question concern is the fundamental constructing block in Framework Manager. A query situation is a fixed of query items that have an inherent relationship.
Question 38. How Can I Convert A List Report/pass Tab Report In Cognos Ep Series Into A Bar Chart Or Pie Chart Etc.?
This can be finished in Impromptu administrator.
Question 39. How Many Numbers Of Cubes Can We Create On A Single Model? How Can We Navigate Between Those Cubes?
Using a single Model, we are able to create as many wide variety of cubes u need. By using the measurement perspectives...And so forth. Regarding the navigation, whilst we save cubes, those act as separator multidimensional databases. There wont be any members of the family. Navigate method commencing the cubes one by one.
Question forty. What Is The Difference Between Group And Association?
In cognos 'group' is used to suppress the reproduction values. And 'associate' is used to suppress the values if it's far one-one courting.
Group - It Eliminates the Duplicate values from the record ruin the columns. Its having a one to many dating.
Association-It Eliminates the Duplicate values from the file and its having one-one courting.
Both Group & Association cast off duplicates in a column.But we can't use Association by myself.It ought to have one to at least one relationship with grouped column.
Using Association is a overall performance enhancement method.
IBM BPM Interview Questions
Question forty one. What Is Cardinality?
Cardinality is nothing but relation among tables like
One to One,
One to Many and
Many to Many.
Cardinality is the nature of the connection. 1-1,1-many relationships Cardinality is the character of the relation among two query objects.
Question 42. How To Test Reports In Cognos?
Go to power play transformer, on toolbar pick out RUN menu. In RUN menu there's one alternative this is TEST BUILD you can check ur document there.
You may additionally check the final results of a report through writing and executing SQL Queries and comparing the outcome with the file outcome.
BY USING SYSTEM TESTING, UNIT TESTING, PERFORMANCE TESTING
IBM Cognos TM1 Interview Questions
Question forty three. How You Create Security To Reports?
Basically there are types of securities for any item Levels of Securities:
Database level Security
Row degree protection
Even we will provide LDAP safety too.
By setting up the Governors in body work manager additionally we can deliver the security to the data getting access to via the record.
Question forty four. How To Configure The Cognos Configurations To Work In The Windows 2000 Server Machine?
Go to Cognos Configuration and notice the settings for cognos within the explorer page. There you could set for win2000 server.
Question 45. What Is Drill Down And Slicing And Dicing What Are The Difference Between Them?
Drill down means it's going to explains the precis level records to lowest stage data.
Slicing is nothing however reducing edge of the cube.
Dicing is not anything but viewing the cube in all feasible guidelines.
Drill down is the manner to get the greater specified records.
Slicing and dicing is to get the facts according to where clause.
Question forty six. What Are The Enhancements In Cognos Reportnet ?
Enhancements in Cognos reportnet is Cognos 1.Zero, 1.1, MR1.1, MR1.2 Cognos 1.0,1.1, MR1.1, MR1.2 AND cognos eight, 8.1.1MR, 8.1.2MR, now new version is eight.2
Enhancement in cognos in the list file:-
Apply list column name patterns
Apply listing column body styles
Apply desk patterns.
Question forty seven. Explain The Different Stages In Creating A Report In Cognos Report Net?
Open cognos connection in that pick Report studio or question studio it will shows there you have applications(ex: gosales and goretailr (defult)) click on on that it show Report studio in that select Object pane choose required query issue then click on run it displays your report on document viewer display screen.
Question 48. What Is Report Item?
Report object is not anything but a query item when it's far drag and drop into the paintings area.
Example in Go income and retailers package deal-> Product (is a question subject) and-> Product line is(a question item)->whilst PL is dropped into the paintings area then its a record object.
Question forty nine. How To Perform Single Sign In Cognos By Using Url?
In cognos configuration below authentication allow anonymous get entry to should be fake.In cgi-bin houses (under iis) the allow anonymous get admission to ought to be false.
Question 50. How You Migrate Reports To Cognos 8 From Previous Versions?
the usage of deplyement device we can migrate the reports.
Question fifty one. What Are The Filters In Framework Manager And Report Studio?
Filters in framework supervisor are
1. Standalone filters
2. Embedded filters
Report studio Filters are
1. Detail filters
2. Summary filters
Question fifty two. What Is Iqd? What Is Contained In Iqd?
IQD stands for Impromptu question definition. It is report store extension with .Iqd it is use for developing a cube in energy play transformer.
IQD is Impromptu Query Definition. It contains the SQL question to display the facts from the database and SQL question is routinely created primarily based at the columns selected from database.
Question 53. What Are The Special Features In Cognos Reportnet?
CRN is net primarily based device. So it will very beneficial to view the reviews very without difficulty. So that they favored CRN
Question 54. How You Create Iqd In Reportnet Framework?
Open framework supervisor click on on any query situation and cross Open the residences talk container and you could have a look at the EXTERNALIZE METHOD you convert the iqd.
Question 55. How To Pass Multiple Values From Pick List Prompt To Sub Report Filter?
#parameter1#. Give this in ur clear out wherein u bypass a couple of values
Question fifty six. What Is Stitch Query In Reportnet?
Framework Manager generates a separate question for each 'FACT' desk and joins the result set that is referred to as Stitched query.
Question 57. What Is Snapshot ?
A Snapshot is a Permanent Local Copy Of the Report.Snapshot is Static Data Source it is stored with .Imr File it's miles appropriate for Disconnected Network.
Question 58. What Is Cube Size?
2.0 GB (It depends in your venture requirements).
Question fifty nine. What Is Log In Cognos?
While growing reports or developing models logs have all statistics till consultation closed.
Question 60. What Is Associated Grouping? And How It Works In Cognos Impromptu?
You can associate one or greater information objects with a grouped information object. An associated facts object ought to have a one-to-one dating with the grouped data item. For example, Order No. Is a grouped records item.
For every order range, there is an Order Date. Order No. And Order Date have a one-to-one relationship.
Question 61. What Are The Limitations Of Cognos Reportnet?
In CRN we can not view multi dimensionally,
we cant' see a file in excel,
we can not format a record in CRN
Report net does no longer guide drill through and additionally bursting of reports is not any viable in report net. Also it does now not guide dimensional analysis.
Question 62. What Is Loop In Framework Manager ?
Loop is an very dangerous exception in framework manager we will solve the loop create alias table. Loop Display incorrect effects inside the reportnet. A Loop is a Closed Path Circuit.
Avoid loops: the usage of shortcuts.We have ambiguous relationships types:Hierarchical relationships Recursive relationships Multi-legitimate relationships. To keep away from these relationships the usage of shortcuts.
Question sixty three. What Are The Different Ways Of Adding Data In Transformer?
In transformer you import metadata from architect or catalog to create a cube. We just import metadata. We don’t upload information to it.
Question sixty four. What Are Slowly Changing Dimensions? Why We Are Used Scd?
Slowly Changing Dimensions are those whose facts aren't constant.
SCD type 1: Whose statistics isn't fixed.
Historical statistics are not saved. Data maintains on converting.-> Current Data
SCD kind 2: Whose data is constant and additionally keep historical records.
SCD kind three: Like SCD kind 2 handiest but store ancient facts in every other table. In one table records will up to date and in some other table historical records could be there.
Question sixty five. What Are The Names Of The Reports That You Prepared?
List document, Cross tab record, pie charts and so forth.
Master detail, Drill via, CascadingList, Cross tab, Chart, Map record are the fundamental document of Cognos.
Question sixty six. What Is The Importance Of Dimension In The Cognos.?
Without Dimension and Fact cannot make a relation among tables it couldn't be use for joins and retrieve the information as a shape of news in cognos. Dimension is a first-rate concern vicinity thru which we can evaluation our commercial enterprise.
Question 67. What Is Exact Catalog Size?
There is no restriction for catalog length. It can be 3MB or 4MB.
Question sixty eight. Give Me Some Examples For Lifecycle Reporting, I Mean Which Lifecycle We Will Use For Reporting?
There is no particular reporting lifecycle. We can generate the reports from records warehouse/facts marts or we are able to generate the reviews directly from OLTP structures.What I imply generating reports from OLTP systems is loading information into one machine and producing the reports. But this is not encouraged. This will depends at the enterprise.
1) Generating reviews from the OLAP interface system retrieving the records from the statistics warehouse to producing paperwork and reports.
2) They can use Business intelligence mission existence cycle.
Question sixty nine. How Many Levels Can Be Used In Drill Through Reports?
Two stages: precis and detail.
Question 70. Where You Can Save The Report Net Documentation In Our Local System?
Whenever we Install Cognos Server we get it documentation by myself otherwise we will keep it in Deployment Folder of Cognos.
Question seventy one. What Is Model And How To Create Model And How To Test Model?
Create a Model In framework Manager after which submit it, ensure that Model meets the necessities, do not overload the model with undesirable query objects.
Model is nothing but a mission. And the undertaking may be created by means of framework supervisor in which we can extract the metadata from the various operational assets... We can test the version by way of using the TOAD.
Model includes meta facts which is associated with enterprise reporting Information. We import this facts from the facts base. Using this metadata we're growing Packages, Publishing programs, This metadata includes query subjects and namespaces.
Question seventy two. How To Create Cubes In Transformer ?
Cube may be created by way of the use of one-of-a-kind statistics resources.
Data assets: iqd, tex file Cube advent by using iqd statistics assets.
These iqd sources are coming from impromptu.
Question seventy three. How You Burst The Reports? If You Are Bursted Reports Is Not Reached To Destination How You Identify?While You Import Data Into Catalog You Have Complex Columns Names. How Do You Change The Name Of Those Columns?
First you need to click on column header which you need to exchange. Then in property pane you will determined name option. Then alternate column call.
Question 74. How To Create Measures And Dimensions?
By the usage of the Framework Manager we will create measures and dimensions in step with our enterprise desires.
Question 75. What Is The Difference Between List Report And Crosstab Report?
List report display data in rows and columns versus a cross tab report show facts in grids with measurement in rows and columns and measures in cells or inside the intersection factors.
List Report and Cross tab document both consists of rows and columns however difference is listing file is a element report for analysis while pass tab record is the intersection of data or summarized data for evaluation.
Question seventy six. What Are The Migration Tools Available In The Market With Respect To Cognos Such As Impromptu Reports Are Migrated To Cognos Reportnet?
Reportnet1.1 migration device is available to migrate the impromptu file to reportnet.
Question 77. Can Reportnet Supports Cubes?
Question 78. How You Provide Security To Reports? How You Provide Security To Packages ?
For framework supervisor applications, earlier than you head away with developing a brand new package deal it asks whether or not or not you want to have security set up for the package deal in use. Even if you haven't described any security at this degree, you may continually goto the actions >> package deal >> Edit package deal settings and there you may define the safety settings for the package.
For reviews, you may both give document-stage or folder- degree safety through going to the homes of that and deciding on suitable roles/user groups which are alleged to be entitled to view/regulate/create reports.