Search results for query: *

Thanks all friends for response! I have considered what drlex said creating a url link in upfront portal,but like winkid1 said that security will be a problem,must write some api or script to check user session before download the spreadsheet file.I now create url link to a ASP file,througth the...

In upfront portal upload a spreadsheet file updated daily,but after the spreadsheet file was updated the uploaded file cann't update automaticly.must re-upload the new version of spreadsheet file by manual.How can I make it synchronize between spreedsheet file and uploaded file? Thanks!

Query has a tabular Model including two tabular Model(tabular1 and tabular2),I want to make a outer join between tabular1 and tabular2.I don't know how to do.Someone can tell me about it,very appreciates!

You can see SQL Statement of Query,whethere the genarated sql have your filter or not

you can set its property [Query] as existing query. Now you can use it like a tabular.Add the query item in above level

I drag a tabular sql into query,how to call store procedure in the sql statement? using exec and call both are invalidate.

Thank CRNUSER Error message: QE-DEF-0285 Logon Failure QE-DEF-0325 The cause of the logon failure is QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: testdatasourceconnection UDA-SQL-0432 Unable to locate the gateway 'cogudaor=msolap'.

You can select report expression property for column current month,next and next+1.Expression is defined like following: Current Month: case month(now) when '1' then 'Jan' when '2' then 'Feb' ..... when '12' then 'Dec' end Next Month: case month(now) when '1' then 'Feb' when '2' then 'Mar'...

In ReportNet cognos connection ,I create a datasoure with others type,the connect string is 'Provider=MSOLAP;Persist Security Info=False;User ID=sa;Data Source=dvt002;Location=test;Mode=ReadWrite;Client Cache Size=25;Auto Synch Period=10000'. Error QE-DEF-0285 Logon failure display when testing...

When users view a list report in report viewer,clicking the column header want to sort can exchange between ascending and descending.How to do it? Can someone help me?thanks!

If so,it's very annoying to set the entries securiry. Design of security is failed,isn't it?

ReportNet use Cognos Series7 NameSpace authentication,user class can't inherit.For example,userclass B is a child of userclass A.User a1 belongs to userclass A and user b1 belongs to userclass B. Now,I want to all useres, which belong to userclass A and userclass B,can access report named...

I create a schedule for a report at ten o'clock every night,but it cannot run always.It can run successfully if Manual do it. Why it is bug.

you can try Avg({([Time].members)},[Measures].[Quantity])

I meet the same problem,can you tell me how you solved? thanks!

create datasource with provider:Oracle Provider for OLE DB, when i process the multi-dimension dataset occur the following error: ORA-01403: no data foundRECORD=1,; Time:2004-6-15 16:37:09 change provider into Microsoft OLE DB for Oracle,when i create multi-dimension dataset, at the step...

thanks,i use view also in MSTR,but i want MSTR how to use union. agent can sale item to othe agent,one transaction is recorded in t_db; agent sale item to final customer,these are recorded in t_so.

t_db.id is uniquely and t_so not uniquely,because one t_db.to_cust_id may sale many t_so.to_cust_id.

in t_so if id is not missing(value is null) t_so.from_cust_id can find a match with t_db.to_cust_id by t_so.id=t_db.id,so the sale path is t_db.from_cust_id to t_db.to_cust_id to t_so.to_cust_id. if t_so.id is null the sale path is t_so.from_cust_id to t_so.to_cust_id.

t_db and t_so are fact table,t_db save the agent transaction each other, t_so save sales data agent sale the customer