Using Command task in the workflow

Hi, this is my first question here. I am facing a problem 
that there is a Cognos report in which a column out of, 
say, 10 can only be viewed by report administrator. The 
other 9 columns can be viewed by all common users. Could 
anyone tell me any hint of how to do so? It seems the 
package, data and object securities taught in Framework 
Manager student guide are not possible solutions...

a column is nothing but a data item that comes from the 
framework side. so the solution lies in your own question. 
you have to do an object level security at the framework 
side to hide the particular data item or the query item

Thank you for your hint!

Depending on the project it varies... 
in general 3 - 4 facts and 15 - 20 dimensions can be there 
in a medium scale project

NOT more than 16 Dimension.
cuz a Fact table can have maximum 16 foreign key only.

-palz-

A relationship between summary and detail information.two
list reports can be merged using master detail relationship
.In master detail relationship both summary&details can view
in same report. to establish the relationship there should
be a common column between the two list reports

used to link the two reports. For ex we have one master 
report in this we have Product line, Quantity, Revenue and 
one child report in that we have Product type we can link 
the two reports child report will show the data depends on 
the master report

This is hyperlinking.The cell can be defined as a hyperlink 
and parameters can be passed to the destination report to 
open.

Insert a vertical table on the existing table or click drag
drop the rows into columns

BY USING ALETER we can display each row in different colour

Using Aleter, we can display each row in different colour

you just give bgcolor for each row  ie in <td>

 Eg :

  <td bgcolor ='blue'><input type=text  
          value='firstline'...></td>
  <td bgcolor='red'></td>
  <td bgcolor ='blue'><input type=text  
          value='secondline'...></td>
  <td bgcolor='red'></td>

Errors:
1) # Multivalue
2) # Errors

Errors in BO

#Multivalue: When any variable yield more than on result

#Syntax: Occurs when we remove any object from report that 
is used in the formula of nay varibale.

#Error: Generic Error

#Incompatible, Context Error: Generally occurred when we 
context is not properly defined for calculation and when we 
try to place two incompatible objects in one table.

#Div: Divide by Zero

in web intelligence we can shedule report as well in cmc.
once you have written the query and run it.and save it to
folders.and open that folder to shedule the report.
in cmc you have an option to shedule the report.

You could see the option of scheduling in infoview,right 
below your report...otherwise u cud schedule it from 
Central management Console

Using Central Mgt Console.

B.O 6.5:-- > 3tier architecture > Rep created after the 
installation  > In Webi wise :-- > There is no alerters & 
There is no merge option 
> In 6.5 Contains 57 tables are there > 
In security level wise also some changes are there : 
> in supervisor acess security servies option is there.

>In 6.5 There is no Casading prompt.
> Here separate  Supervior & B.C.A  

BOXIR2 : Desiner wise-- > directly to restict data in 
designer level. > New feautuer is Cascading prompt 
Webi wise : > here alerters & sub alerters also possible
> Merge Option is also possible

> BCA + Supervisor combined in CMC.
>doc domain & uni domains are located in form of folders
> here secured & Saved in folders & categories.
> Sheduled directly in Webi.

Your question is not clear, I am assuming a, z as variable 
names.
In the input statement 
Input a-z; It is a number range list from a to z.
input a--z; is the name range list between a to z.

a,z as variables names.

In the input statement 
input a-z; it is a variables from a to z
input a--z; it is also the range from a to z variables

var a-z : this shows error message because it does not have 
any numeric suffix
var a1-a5: it diplays variables a1 to a5
i.e it only shows variable ranges

var a--z : it displays a to z it includes variables between
a to z
ex;
data k;
input a b c z;
datalines;
1 2 3 4
5 6 7 8
;
proc print;
var a--z;
run;
proc print;
var a-z;     >>>>>>this shows error:numuric is not there
run;

data k;
input a1 a2 a4 a3;
datalines;
1 2 3 4
5 6 7 8
;
run;

proc print data=k;
var a1-a3;
run;

proc print data=k;
var a1--a3;
run;

1. To create link between FWM and DB(Source)
   Open FM-->File-->New Project-->it will ask you to select 
DATA Sources..we can select new DS to create or existing to 
connect.If you select 'new' it will ask for type of ds 
(Oracle,sybase) and click next then give Connection string 
and userid/pw .then test for connection.if the connection 
is succeeded.connection is established between model and DS.

2. Once model is created..it will be stored under projects 
in location where C8 is installed.
(eg) if your modelname is 'sample' then it will be stored 
as 'sample.cpf'..C:\Program files\C8\samples..

3. I you create reports..it will be stored as specification 
in .xml file.

place the connection in the connection slot --use  "ODBC 
connection" option here.
while placing the data source in the data stream 
choose "Stored prodedure data source componant" ,click on OK
Place the data row in the data row slote under data stream .
Now double click on the data stream go to Property-Stored 
Procedure Def ,click on the browse button ,
then it will automatically opens the SP in your database , 
just select the stored procedure (SP) which u want