Search results for query: *

Hi All, I have a problem with the prompts and filters.I have a hierarchy,country-region-city etc and we set preferences for the head of each level in narrowcast to get the personalized report.For a country head, I have to display all the regions(one level below country) in a country and metrics...

Hi FLB,I got the solution for the 1 problem which is becos I used outline mode.The 2 problem is,I am drlling from an attribute to a template.In this template, I have like 7 or 8 metrics in rows and 1 attribute in column.For each value of the attribute, there will be one column.The problem is a...

Hi FLB, Yes, either I could have used attribute roles or create table alias in the tables folder. Since I am new, I couldnt get this solution immediately, Thanks for the suggestions. mstms

Hi, I found the solution for this problem, if we have to join the same column more than once, then we can create an alias of the table in the schema in microstrategy and we can join against the same column from the alias,Any way thanks for suggestions from iolaper. mstms

Hi,1)I am drilling from an attribute to a template and these attribute elements are underlined, the underline is extending outside, what may be the reason for this,2)In web,a large gap is being shown between columns and rows, how to reduce this, If any one has answers, please do suggest me...

Hi Iolaper,i am joining the leader id, segment id etc with person id in person lookup table becos a12.esa_person_id contains ids for all the seg leaders, sect leaders, ind leaders etc.The person(employee) attribute contains only the a11.z_prsn_oprid,a12.esa_person_id in mapping,but I am also...

Hi Iolaper,Yes, as you said,a11 is fact table and a12 is the person lookup table,and a13 is the dept dimension table,the fact table stored for each employee(z_prsn_oprid)and to get the name of this employee we use first join,each employee belongs to a department which belongs to a segment,the...

Hi, I have a problem with joins.person id,person name are stored in one table.industry headid, sector headid... are stored in other tables,which I have to join with the person id to get the name.Hence this person id is queried 4 times. a11.Z_PRSN_OPRID = a12.ESA_PERSON_ID and...

Hi,Thanks for your suggestions,I kept both the options as nate and iolaper said and the DBA agreed to create the view,The report worked atlast,Thanks,nate and iolaper,for the quick responses. mstms

Hi,I wanted to create an attribute which displays 2 columns from 2 different tables in one form.To say in detail, TABLE 1:SECTOR ID,SECTOR LEADER ID TABLE 2:PERSON ID,PERSON NAME I can join the 2 tables using SECTOR LEADER ID and PERSON ID and I have to display Sector ID (person name) in one...

Hi teccum, Thanks for your prompt reply, what you suggested worked good,I removed the 'sum' set in the subtotals/aggregation and checked the 'allow smart metric'and now the metrics are giving right values.Do you have any idea what the 'sum' option in the subtotals/aggregation does since this...

Hi teccum, Thanks for your reply,but i checked all the joins for all metrics and set it as outer,but the same problem occured,after that i set the dynamic aggregation in the metric editor to sum in both the compound metrics and it is working fine,but i couldnt understand what difference it makes...

I have 2 compund metrics which use columns from the same table in the report, when I run report, I could see data in all metrics except the 2 compound metrics,but if I run the Microstrategy SQL in database, I get values for these compound metrics, Can anyone help me with this, Thanks in advance.

Hi FLB, Thanks for your reply,This is really helpful to me, mstms

Hi Z3, thanks for your reply, i am just wondering what the second apply comparision does here when it combines with the first one, thanks

can any one tell me how this apply comparision works in filtering the MTD values of cycle id which is the date, when a particular date value is given in the prompt. filter mtd applycomparision(“#0<=#1”,cycle(ID),{cycle date prompt}) and applycomparision(“#0>=(select distinct...