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!

  • Congratulations Wanet Telecoms Ltd 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
  • Content: Threads
  • 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, 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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 ?
  7. 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 .
  8. 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
  9. Rambo2292468

    Ugly SQL generating with Lookup and FACT joins for homogenous Key

    please see the query below : select a11.EMPLID WFI_PERSON_ID, max(a16.WFI_PERSON_DESC) WFI_PERSON_DESC, a11.VC_AWARD_DT VC_AWARD_DT, a11.IN_GUIDE_CNT CustCol_5, max( CASE WHEN a11.IN_GUIDE_CNT =1 THEN 'Y' WHEN a11.IN_GUIDE_CNT =0 THEN 'N' ELSE 'UNKNOWN' END) CustCol_17, a11.PER_DIM...
  10. Rambo2292468

    outer join in reports Not to all lookUp

    I am facing following problem I have one fact table and 8 DIM tables as lookup Action performed : did setting in VLDB propertities to preserve all Look up table......... result:It creates left outer join for all lookup but i need to apply left Outer to only 3 Dim table than all 8 Query: I...
  11. Rambo2292468

    Attribute Editor

    Query :When I double click the attribute object it does not open directly instaed it resides on my Task bar and to open the editor I have to right click and select maximise . Any early help would be really appreciated rash

Part and Inventory Search

Back
Top