Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Rambo2292468
  • Order by date
  1. Rambo2292468

    Attribute decimal display

    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...
  2. Rambo2292468

    Timed out error when report returns more than 100000 cell

    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
  3. Rambo2292468

    Timed out error when report returns more than 100000 cell

    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...
  4. Rambo2292468

    Timed out error when report returns more than 100000 cell

    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...
  5. Rambo2292468

    Timed out error when report returns more than 100000 cell

    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...
  6. Rambo2292468

    Display Simple Metric(Count) based on condition

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

    Display Simple Metric(Count) based on condition

    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...
  8. Rambo2292468

    Report Error

    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...
  9. Rambo2292468

    Column Type displayed different in Backened and MSTR Warehouse catalog

    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...
  10. Rambo2292468

    Column Type displayed different in Backened and MSTR Warehouse catalog

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

    Column Type displayed different in Backened and MSTR Warehouse catalog

    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...
  12. Rambo2292468

    MSTR 7.5.1 Documnet Object Display Null Columns

    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...
  13. Rambo2292468

    MSTR 7.5.1 Documnet Object Display Null Columns

    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"...
  14. Rambo2292468

    MSTR 7.5.1 Documnet Object Display Null Columns

    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...
  15. Rambo2292468

    MSTR 7.5.1 Documnet Object Display Null Columns

    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...
  16. Rambo2292468

    Load on Serevr

    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 ?
  17. Rambo2292468

    Project Alias

    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
  18. Rambo2292468

    Graph Export to Excel or PDF

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

    Project Alias

    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
  20. Rambo2292468

    Ugly SQL generating with Lookup and FACT joins for homogenous Key

    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...

Part and Inventory Search

Back
Top