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 SkipVought 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: *

  1. robpotter

    Preparing for TeraMiner project

    I would like advice regarding an upcoming teraminer project. Any suggestions on the best forum or recommendations for assistance specifically on NCR's datamining toolset. Thanks in advance. Rob
  2. robpotter

    Alternatives to VS without large run-time downloads by users

    Thanks for quick responses. FYI- I am developing small utilities that will benefit from breadth of .NET classes. One of them uses the MD5 digest to encrypt/decrypt and integrates with MS-Office apps. Rob
  3. robpotter

    Using VB instead of VS to avoid .NET download by users?

    Hi all, Would Virtual Basic 5 or 6 remain a viable alternative to Visual Studio 2005 in order to avoid large run-time downloads by users? I created a small app the new using VS 2005 but apparently C# always is dependent on the .NET run-time environment(dotnetfx). With its nearly 25 MB, that's...
  4. robpotter

    Alternatives to VS without large run-time downloads by users

    Hi all, What are alternatives to Visual Studio without requiring large run-time downloads by users. I created a small app the new using VS 2005 but wanted to confirm whether C# always is dependent on the IL run-time interpreter that is part of .NET 2 (dotnetfx). With 24 MB size, that's a...
  5. robpotter

    Performance of Analytical Engine CASE function vs. DBMS

    Thanks very much, entaroadun I didn't know that Analytical Engine didn't perform the Group by on attributes. Since aggregating by groups is requirment, I'll stick with the Applysimple. Of course, in performance testing, we may determine that all encoding should be pre-calculated (even simple...
  6. robpotter

    Performance of Analytical Engine CASE function vs. DBMS

    Question on Performance of Analytical Engine CASE function vs. DBMS CASE using Applysimple For reporting off large tables that will join with security views, our data mart designs have the majority of transformations as pre-calculated fields that arestored in the fact tables. However, a few...
  7. robpotter

    MSTR not recognizing new columns in SQL Server table

    entaroadun Thanks for quick response. I thought I had tried clicking on table from within warehouse catalog. Rather, I must have done something else like left-click. Now the new columns appear within schema. Rob
  8. robpotter

    MSTR not recognizing new columns in SQL Server table

    Need advice on urgent issues: MSTR 7.2.0 Desktop not ecognizing new columns in SQL Server table. After I added new physical columns (alter table) and populated them (update table), MSTR warehouse schema will not recognize the new columns in tables. I have checked the column datatypes and...
  9. robpotter

    Question about @Select, @Where

    Thank you Steve, What we are really interested in achieving is finding alternatives to relying on report varibles for defining "derived" metrics to reduce report maintenance. Of course, BOBJ does projection from microcube to bloc and the variables (aka derived metrics) must be...
  10. robpotter

    Question about @Select, @Where

    We have measures defined in Universe as well as variables that are derived those measures defined in WebI. Since these are employed in standard reports, there will be maintaince issues. However, I would like to migrate the defintions of variables from WebI to Universe. I was thinking of using...
  11. robpotter

    Apply functions

    Thanks nlim, Your reply was helpful. Since I am using 7.0 I couldn't use several of the nice enhancements in 7.2 (aka 7i). Actually, I have to thank you for your earlier posting from May 2002 (See thread395-278718) where you replied about calculating min of two values. I tested using internal...
  12. robpotter

    Apply functions

    I implemented several ApplySimple to Oracle in MSTR 7.1 with this structure in order to handle nulls and no Least function. ApplySimple(&quot; CASE WHEN NVL(#2,0) < NVL(#1,0) THEN NVL(#1,0) ELSE Least(NVL(#2,0)-NVL(#1,0), NVL(#1,0)) END &quot;, Sum(Fact0),Sum(Fact1), Sum(Fact2)) -> One...

Part and Inventory Search

Back
Top