Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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