Search results for query: *

Hi, I have an attribute named Quantity. I use the formatting below (backend data is teradata) to display the data with decimal: ApplySimple(" cast(cast (#0 as decimal(12,3)) as char(12))", [item_required_amount]) From this formatting, it displays the data as follow: 1.000, .000, 1.123...

Hi, We chnaged machine.config file from Default is 90 to 600 but issue didnt get resolved. Yes but I did not chnage Web.config should i change that too. Thanks Rambo

Hi Eoloper and Pp About these setting I am aware and we already have the following setting and still getting error: #1: Web timeout is currently set to 3600 seconds: #2 JVM Heapsize is currently set to 850MB Any comment on this?? PP: based on what we can select right setting i mean as you...

Hi Iolaper, I get timeout error when I run from the web browser sometime. With the same selection, I can run the report from desktop without any issues. I also compare the sql generate from desktop and web browser and they are matching. Here is how I understand the report works: From web...

Hi, I am aware of the I-server 100,000 cell limit for export and 32,000 row limit for I-server but something strange happend that when we try running the report and if the report returns more than this limit it gives error as Timed -out on web browser. Anybody aware of this is this a bug or...

This helped ...thanks Nlim nice solution!! Thanks once again Rambo

Hi, I have a simple count metrics but I need to display the metric value based on some condition like: if count <2 then display 'NA' or 'blank' whatever can be achieved easily. Else Count I know how to do using Applysimple or Case statement. I would like to knwo is there any...

Hi Leo, I guess you using teradata as a backend. Seeing your sql here two suggestions : 1. It looks like in the last pass you have sql with inner join where you data might be getting filter. Try to check on Backend by replacing inner join with left outer or full outer join in the query below...

HI Johnoward, you got me correct. You are right my database is sql 2000 and what i experienced in couple of poject that if we update multiple tables/view and have the same column name in different tables/views in the warehouse with different column definitions, MSTR will take the last...

hi teccum I have done this many times it changes all but show 2 times more for VARCHAR datatype in the warehouse view. Thanks !

Problem: MSTR warehouse did not pick up the correct datatype when the backend view update. In the backend view, production_start_date and production_end_date shows varchar 21; however, they are varchar 42 in the view in warehouse. Here is the backend view: V_Workcenter_itm...

Hi iolaper, Thanks for such quick response firstly I am not using reporting services I am using documnet object in MSTR 7.5.1. and I did customized the xsl sheet to display metrics in between attribute but now user want afew blank metrics in between so I had to modify the report and xsl...

Thanks leo and iolaper it is very helpful. Leo , yeah same here I tried making metric suing "ZeroToNull" and whe i try puting the metric in report it asks me to update the schema.. Threshold metric did work. But as I have 3 null metircs in one report i was thinking of uisng "ZeroToNull"...

Hi, I knew how thsi can done in database but i dont want to do that. I would like to go for your second recommendation i.e duplicate the metrics and use treshold (to say replcae everything) how actually you do this can you please eloborate little more on this. Thanks a lot all efforts are much...

Q1. I have a report running using Document and we customized the report and have chnaged the formating of the report like metrics in between. My question is : Can we Create a null comlumn (No data) in the Document object ? if yes waht would be best way to achieve this. Early response would be...

Subscription – I am wondering that whether it will add an extra burden on performance. Please let me know does keeping Subscription faciltiy avaiable to USER will increase load on server if yes how much ?

Hi, Thanks for the reply . yeah I got to know MSTR has removed this feautre in 7.5.1,however I could resolve the issue by giving Desciption with Project name .Kind of workaround used to achieve what was needed

How can we export Graph to excel or pDF ? using IE 6 and windows NT . When we export it get a blank image .

How to have Project Alias on web in 7.5.1 .Which means my Project name is LIKE MSTR-Porject but on web I want to display as MSTR-Project-production.. </b>PS:In 7.2.2 I know but it seems in 7.5.1 it is not same</b> Rambo

Thanks entaroadun, Yes You got the issue , there is no difference except runnning time , I mean I did get same result set but time to run with extra join is more than without . But if . If the warehouse data has good integrity, this logic does not cause any issues. But it seems it is...