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

  1. dlutzker

    Unable to refresh in Webi

    I have already restored a recent backup; losing recent changes is not an issue. After the restoring the repository database we lost ALL connectivity from the WebI login. Now it is looking for the BOMain.key file. We have three environments (security domains) and the BOProd.key file is still...
  2. dlutzker

    Unable to refresh in Webi

    PLEASE! I HAVE THIS PROBLEM! I have done a 'Save As', but with the same name, and then I exported it immediately and overwrote the old one. Does this mean that all my old reports will not work?? Is there a remedy??? Thanks. Dave
  3. dlutzker

    URGENT SQL generating issue - join two tables on multiple columns PLEA

    [2thumbsup]Well, a happy ending to this saga. I opened a case with MSTR tech support, and they insisted that the logical table key calculation was functioning as intended, so I re-examined the "lowest level" of each attribute that was in the key, and those that should be in the key. And herein...
  4. dlutzker

    URGENT SQL generating issue - join two tables on multiple columns PLEA

    entaroadun - If it is a case of corrupt metadata, than there is still hope. I am working in the development/test environment, and the attribute in question ("Program", and BTW it does not have multiple expressions in it's ID form), is in the current production system. The logical table, and...
  5. dlutzker

    URGENT SQL generating issue - join two tables on multiple columns PLEA

    Thanks to both nlim and entaroadun! Before I try nlim's suggestion I will work on entaroadun's idea, because in fact the SDW_ORDERED_EXAM_FACT_SS logical table has an incorrect table key defined. It is not a unique definition, and it uses a pass-through SQL attribute, and excludes...
  6. dlutzker

    URGENT SQL generating issue - join two tables on multiple columns PLEA

    [sad] Well, I extended the fact in question to Program using a table relation (since there is a PK-FK relationship there anyway). I updated the schema, and checked the SQL for the report. Unfortunately, it gave me the same results. I got the same SQL that I had in that first pass in my first...
  7. dlutzker

    URGENT SQL generating issue - join two tables on multiple columns PLEA

    Metric #1: What seems to be missing is an entry point for Program. As I mentioned earlier, Program sees all the relevant fact tables, including this one. While I am not adverse to creating a fact extension for this fact, I don't see why the entry level shouldn't be there. Program_Dim_ID is a...
  8. dlutzker

    URGENT SQL generating issue - join two tables on multiple columns PLEA

    I am looking at the fact entry levels, and I may need to make some changes here. I assume that the entry levels are determined only in the hierarchy editor, and that to make changes, I will need to make sure that the attributes I am using in this report are in the appropriate hierarchy, with...
  9. dlutzker

    URGENT SQL generating issue - join two tables on multiple columns PLEA

    Metric #1 is a count of a fact, which is actually a flag. It has levels for "First Completers Exam Taken", Program and Report. The condition is the sequence (rank) = 1 to ensure it is the first exam taken. Metric #2 is a Count of a fact, but the fact is the Completer_Fact_ID. No level or...
  10. dlutzker

    URGENT SQL generating issue - join two tables on multiple columns PLEA

    Okay - I am attempting to get numbers and the ratio between them for the following two metrics: The number of students who took that exam first, within the specific program (regardless of whether they passed the exam, or completed the program. Hence, the use of the SDW_ORDERED_EXAM_FACT_SS...
  11. dlutzker

    URGENT SQL generating issue - join two tables on multiple columns PLEA

    For better or worse, this is the way I get the first exam taken by a student who completed the program. The TAKEN_EXAM_SEQUENCE field is a text string of the exam names taken, separated by commas. When there is no comma, there is only one exam listed. Otherwise, I take the substring up to the...
  12. dlutzker

    URGENT SQL generating issue - join two tables on multiple columns PLEA

    nlim - I appreciate your taking a look, but the Program attribute, which does mean the same thing across the entire data warehouse, has all the related tables defined, including the two from that first pass. Any other ideas? Anybody else? I am stumped! Dave
  13. dlutzker

    URGENT SQL generating issue - join two tables on multiple columns PLEA

    I have been grappling with a problem joining two tables that need to be joined on multiple columns. One metric is joining correctly (the second pass), but the first one insists on remaining joined on one field only. In general, how does the SQL engine decide when to join on multiple columns...
  14. dlutzker

    SQL Generated is Inconsistent

    nlim - wanted to thank you for sticking with me to the end. You are right, and your solution worked, so first of all, KUDOS! I hope it is appropriate to give you a star for this, even though I don't think this thread will be particularly helpful to anybody else, but it was to me. Note to...
  15. dlutzker

    SQL Generated is Inconsistent

    nlim and others, No such luck. The two times are different: time of completion of a program, and time of taking an exam. They should be separate. But I would think I could report on data from each, while filtering on the same year in both fact tables. I tried to add the second year...
  16. dlutzker

    SQL Generated is Inconsistent

    nlim - you are right! I put the Exam_Year on the report, which sees only the view SDW_EXAM_TIME_DIM_VW, which sees only SDW_EXAM_FACT, not SDW_COMPLETER_FACT. But...... When I built these attributes I understood MSTR would want to keep the Time_Dim's separate - so I have two views (SELECT *...
  17. dlutzker

    MicroStrategy Vs. Business Objects

    I can give an unbiased view of these two tools, having used both of them quite a lot in the last 2 years. I am a consultant, with no axe to grind, nor any partnership or encumbrance with either one. Business Objects Advantages: User interface for intermediate to power users is easier to use...
  18. dlutzker

    SQL Generated is Inconsistent

    I am writing a report that combines metrics from two fact tables, but both are on the same level: From SDW_Exam_Fact I am counting contact_lu_id's at the program level From SDW_Completer_Fact I am counting Fact_ID's at the program level (the fact table itself is the unique combination of...
  19. dlutzker

    Difficult Crosstab report - need your design advice!

    I like your suggestion. I could perhaps add another FK to the existing fact table for Next_Program_Dim_ID? Do you think there are advantages to that? I try to explain some of the funky things that I have seen Microstrategy do (the sql engine) and it seems to use all the information it has...
  20. dlutzker

    Difficult Crosstab report - need your design advice!

    entaroadun - good question. I would ideally like to include someone who started another program, but not completed it in the analysis. However, that data will only be found in a different schema, and I fear that it will be overly complex too achieve. I would also like to include the...

Part and Inventory Search

Back
Top