What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

1. Create a new namespace.

2. Create a new query subject inside IQDReportNet.

3.In the query subject definition window, pull in all the data you need.

4. after creating, click on the new query subject, from the properties pane, select "IQD" from the drop down menu of externalizeMethod.

DONE.

to Publish. u need to create a package.

1. create a new package. a WIZARD will open.

2. Name the new Package; select the IQDReportNet object from the project.

3. add security, select language, select the funtion list(DB), select the location from the WIZARD

4. Publish the package.


--------------------------------------------------------------------------------

Give me any example of semi and non additive measures?
Semi-Additive: Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table but not the others. Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table. Current Balance and Profit Margin are the facts.Current Balance is a semi-additive fact as it makes sense to add them up for all accounts (what's the total current balance for all accounts in the bank?) but it does not make sense to add them up through time (adding up all current balances for a given account for each day of the month does not give us any useful information). Profit Margin is a non-additive fact for it does not make sense to add them up for the account level or the day level.



--------------------------------------------------------------------------------
How can you restrict access onto different parts of report given a report?

In Cognos 8 you can do it in three stages

1) Package Level

2) Object level

3) Data level


Package level

Expan the namespace

R click on package > Click on Edit Package

Package Access window appears

Remove All users from it

Click Adds

select Cognos

Select Report Administrator

OK it

save the package in Framework Manager (FM)

Publish the package

----------------------------------------------------



Object Level

Expan the namespace

R click on a table > Click on Specify Object Security

On specify Object Security window

click on ADD

On select users and group dialog box

select Cognos

Select Report Administrator & Consumers

Click Add

In new window under allow Report Administrator deny consumer

Now R click on namespaces

click on Specift Object Security

Here allow both consumers & Report Admni

Right click on packages

Explore package

window opens

Select Object security tab appears

You will be allowed see who is allowed and who is not

-------------------------------------------------------



Data level

Right click on a table

Select query subject

select specify security filter

specify data security dialog box appear

click on ADD

select cognos

select consumers

Ok it

click the first row

click on insert

In Filters folder

select the appropriate filter

save the package and publish it