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

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.

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