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 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: teccum
  • Content: Threads
  • Order by date
  1. teccum

    Age Lookup table to fact table

    Scenario: Medical Background: Dimensions tables : Provider, DRG, Type of Service, Member, ICD9 Codes, Line Of Business, Age, Time. Fact table: ClaimInpatientFact, ClaimOutpatientfact, ClaimPharmafact, Memberfact. Granularity of Data: Month level. Challenge: Decision to have the Age...
  2. teccum

    Date Prompt Display

    I have a requirement where a prompt which was created based on the date attribute with a " between " operator has to display its values side by side in desktop and it also has to display side by side in the Web instead of the default display of one below the other...
  3. teccum

    Login Restrictions For users

    I have a requirement where the business wants to allow only certain users to login during peak hours (between 8.00 a.m to 11.00 a.m)everyday. So I have to restrict the login of certain users into MicroStrategy. Do anyone have an idea of how to restrict the user login for...
  4. teccum

    Implementation Challenges

    Just wanted to find out the various data warehouse implementation challenges that others are facing out there. Please share your experiences. thanks teccum.
  5. teccum

    LDAP Authentication

    I am trying to configure the LDAP Authentication for the group of users. I have imported the users from the NT domain and have defined the Group Distinguished Name in the Authentication Tab of the Group editor. when I try to logon, I am receiving an error message like "(MicroStrategy...
  6. teccum

    Moving Average Calculation

    I am trying to create a metric involving MOVINGAVG ( moving average function). I am not getting the right answer when I use this in my report. I tried creating Moving Average from the Tutorial Project using the "Revenue Metric" as the value and the window size as 3. My report contained the Month...
  7. teccum

    Comparison between Date to Month value

    I need to create a filter between two different time values. Actually I need to substract the "claim service start date"(which will be user prompt) and then compare it with "Cap Pay Month" (which will be a user prompt of Month attribute - Actually here Month Id is linked to the Cap_fact table...
  8. teccum

    Report From two data sources

    I need to create a report where a part of the data is from the excell file. Basically there is a report which has columns - Budget, Actual(claim net amount for all line of business(LOB) - available in the database), %Over/Under(Total claim amount /claim net amount for a particular Line of...
  9. teccum

    Days - Date Difference

    I need to create a time difference column in my report. Actually, I have to create an attribute called 'Out Of Compliance'. The formula for this is (Claim Received Date - Claim Paid Date) > 60. I have created the derived attribute for Claim Received Date and Claim Paid Date by giving the...
  10. teccum

    SQL Server ODBC error

    All, When I try to access the elements through the system Hierarchy, I get an ODBC error. My datawarehouse database is SQL Server 2000 and I have defined a ODBC DSN in my computer pointing to the datawarehouse database (datawarehouse DSN)in SQL Server and I have created a database instance...
  11. teccum

    Mstr I-Server Service Manager

    I am not able to open the Service Manager so that I can start and stop the service from that. Instead I am doing it through the Windows Services. When I click on the Service manager, it is not initialising or opening and does not return a error message, but the mstr service is running. Is it...
  12. teccum

    Mstr Web Admin Login

    When I try to login into the Web Adminstrator through the Program files --> Microstrategy --- > Microstrategy Web Administrator. I am also able to login through the link in the Web login page where it say's "Go to the Administration Page". It allows me to the web administration page without...
  13. teccum

    Four different data attributes for a dimension

    Hi, I am working on a Healthcare datawarehouse and have few modelling questions. I have a claim dimension which has four different types of date fields. That is there is claim service start date, claim service end date, claim paid date, claim received date. I would like to know how to treat...
  14. teccum

    Mstr Tutorial project in 3-tier

    Hello, I configured the mstr I-Server and then tested it by moving the Mstr Tutorial project into 3 tier by moving it to I-Server. I was able to access the project from another desktop but when I tried to execute the report I get a ODBC error. I am wondering where I am going wrong...
  15. teccum

    Web installation

    Hello, I installed Mstr Web Analyst edition of MSTR Web in a server(SQL Server) which has five partitions. I installed Intelligent server in one partition and Web server in another partition. I did not get any errors and the installation got completed successfully. I checked the Intelligent...
  16. teccum

    Time cal error -urgent

    Hi, I could not run my report and get an error or warning like "Hour must be between 0 and 23" for my formula calculation. My formula for Y is Y = Time (Truncate ({@X}/60), Remainder ({@X},60),00) My formula for X is ((ToNumber (left ({CDMAB.TIME_IN}, 2))) * 60) + (ToNumber (mid...
  17. teccum

    cannot view data in crystal report

    Hi all, I am trying to run a report. I can see the crystal reading the data with the help of the menu bar at the bottom of crystal, but could not view the data and get blank report. could some one tell me what can be the problem of the report. thanks tecum
  18. teccum

    Hi, Could someone give me the ex

    Hi, Could someone give me the exact difference between the target table options in the session, Such as Insert, Update(update as update), Update(as insert), Update(else insert), Delete, Truncate table. Even though info is given in the help file and I understand to an extent. I would like to...
  19. teccum

    DB2 performance improvements

    HI, My project is currently in ver 6.x and the database which we are using now is DB2(we have recently migrated from a different database). Now, what are the settings should I change in project file or dot DSS file of each project with respect to the DB2 database and also what are all the...
  20. teccum

    near line storage

    what is meant exactly by near line storage?

Part and Inventory Search

Back
Top