Search results for query: *

Hi Can anyone tell me which BO metadata table holds BO universe Condition information along with BO Hierarchy information. Is there a UNV_CONDITION or similar table for that. Thanks in advance

Hi, I have a peculiar case There are 2 fact tables. The key of bot the tables is same. Now that key has referential integrity with another master table which has all possible valid combinations of Col1 , Col2, Col3. Now fact1 has records corresponding to records in the master table for all...

Hi, I have a PERL script which connects to a DB2 database from it. Now I have a very complex query on huge data 270 million records . It takes more than 2 hrs to run (this is ok and logical). When I run it from DB2 client its fine--infact the DB2 client remains connected for days. However when...

Hi, I have a problem -- let me try to explain. I have 2 compare data of 2 different databases using PERL. Now that is happening correctly. To show a progress bar I am using TK. Now, when the number of records of the 2 tables (which I want to compare) is huge, then the TK frontend window gets...

Hi, I have 2 database with same tables loaded from 2 different systems. The table structures and values are also expected to be same. I have to write a PERL program that will take table name as input, then output 2 files each from the 2 different databases and then compare all columns of each...

Hi, Can anyone please explain (give references to documents) as to how a session works. Lets consider a map that selects rows from table T1 in database D1 and inserts rows in table T2 in database D2.The table definitions are stored in the Source and Target definitions. Now all these are stored...

Hi I want to write 2 SQLS joined by UNION. e.g. ( SELECT D1.A1, D2.A2, 0, 0, sum(F1.A1), sum(F1.A2) FROM D1, D2, F1 WHERE ........ GROUP BY D1.A1, D2.A2 UNION SELECT D3.A1, D4.A2, sum(F2.A1), sum(F1.A2), 0, 0 FROM D3, D4, F2 WHERE ........ GROUP BY D3.A1, D4.A2 ) Any...

I need to create a report in MSTr which will contain a subquery with a prompt inside the subquery. I thoufht of using Advanced FIlter option where I wrote ApplyComparison . But that subquery in that filter is fine when there is no prompt or atmost value prompts. But my prompt will be elemnt...

Hi All, I have a report with around 32,000 rows. I run it and cache it. It has a prompt. I then include it in Report Services and run it. As obvious it asks for prompt and I give the same value that it stores for hitting the cache. Then it gives "Disk Full" message and nothing is coming . How...

Hi, I have 2 Dim table D1 and D2 and 2 Fact tables F1 and F2 say. Now, I create an attribute A11 to join D1 and F1 and A22 to join D2 and F2. In Report#1 I need to show an attribute A1(from D1),A2(from D2) and Fact from F1. What I did, is create those attributes and added the joins as their...

Hi I have a MSTR report where I have 5 metrics. in the last 2 metrics I have a Applysimple function such that Applysimple("case when #0='A' #1 else #2 end" , ?Prompt1,fact1,fact2) Here Prompt1 is value prompt. All facts are from same table and MSTR generates 1 SQL based on the value of the...

Hi I have 2 fact tables. Now I want to write 2 SQLS for the 2 facts joined by UNION. e.g. ( SELECT D1.A1, D2.A2, 0, 0, sum(F1.A1), sum(F1.A2) FROM D1, D2, F1 WHERE ........ GROUP BY D1.A1, D2.A2 UNION SELECT D1.A1, D2.A2, sum(F2.A1), sum(F1.A2), 0, 0 FROM D1, D2, F2 WHERE...

Hi My requirement is to creat a metric which calculates depending on a prompt value. For example, If prompt_flag=1 the fact 1 else fact2*fact3 Now prompt_flag is a prompt. If I use an attribute elememt list prompt then I can't include it in tghe metric definition. However, if I create a...

hi all, What is the logic followed by MSTR in generating a SQL specifically the From clause order. Say I have 5 attributes from 5 tables. How will MSTR order these tables in the Where Clause? It seems it doesn't do so based on the order the attributes are chosen. Is it possible to make the...

Hi, In a report I have 2 prompts. Now say each can have 2 values. Then the different sets of report combinations is 2*2. Now, is it possible in MSTR to generate the 4 reports based on these values and schedule them? These numbers can increase as well, so it difficult to create all these reports...

Hi , I have 2 tables of which 1 is a dimension table. Another table is joined with it but its not a pure snowflake (our structure is not a pure snowflake/star--there is a lot of normalizations in the db structure). Now I want an outer join on one column between these 2 tables. How to achieve...

Hi I have a fact say F1. Now there are 2 filters fl1 and fl2 on the same attribute but differenty hardcodings (e.g. fl1 maybe a1=1 and fl2 is a1=2) I have 2 metrics M1 and M2. Both are made on F1 with fl1 and fl2 as the Conditions respectively. As obvious when I drag both M1 and M2 in a report...

hi My requirement is like this: I will have a prompt in the report like Date >= Promt(Start Date) and Date <= Prompt(End date) Now these Prompts show list of values but are not mandatory (means skipping these will ideally give all results) However when the prompt is skipped MSTR generates...

Hi 1) If there are 3 reports in a MSTR Document with same prompt. Will MSTR prompt once or thrice? How to make it prompt once but affect all 3 reports? 2) If there is same page by section in 3 reports (only data block changes)then will that be repeated? How to keep only 1 page by for all three...

While running a report I am getting an error: Method '~' of object '~' failed. Any suggestions?? Thanks