All,
I am trying to install a application called Microstrategy on AIX 5.1 box.This is the first time I am working on AIX.The installation fails after some 10% complete.Given below is the text from the installation log file.Do any one of you have any idea what might be the problem?
(Jan 19...
All,
I have couple of general question.
1)Can we connect and work on a IS which is 7.5.2 from a desktop which is 7.5.1?
2)Is it possible to move the objects from a project which is on a server 7.5.2 to a project which is on a server 7.5.1 using object manager? The projects are related.The...
All,
I have a report that is scheduled to run every day early in the morning(around 3:00 AM).This report used to kick of on time as per the schedule at 3:00 AM, run for few hours and get cached after executing.
But from last few days the report kicks of on schedule and after running for few...
All,
There is a report with a filter which is created by the end user on the web.The user wants to edit the report filter on the web to add new elements of a attribute into the filter.When he searches for the elements on the web (using both Match case checked and unchecked )the elements does...
All,
We are unable to start the IS and the event log file has message some thing like given below.Has any one faced same type of problem? if so,any help to resolve it is greatly appreciated.
The description for Event ID ( 0 ) in Source ( MicroStrategy Intelligence
Server ) cannot be found...
I have a report which was running fine.But now from last few days all of a sudden,the execution fails and error message is returned as follows:
(QueryEngine encountered error: Unknown failed. Unable to connect. Error type: System call error. Error communicating with connection process. No...
Hi all,
I have a question regarding scheduling and caching.
A enduser creates a report on web (web professional)and schedules it to run overnight.Now when another enduser executes this same report does it use the cache created by the schedule of another user?
All I want to know is,can a cache...
Hi All,
I have a problem with Enterprise Manager where the reports return no data.I queried the database tables and found that some tables like 'EM_IS_LAST_UPDATE','EM_USER','DT_DATE','IS_SERVER'
tables are populated while other tables such as "IS_SESSION","IS_REP_FACT" are not populated.
Do...
Hi all,
I have a requirement which requires the template to be launched in a separate window on the microstrategy web when user wants drilling to a template similar to how it is done in Desktop.Do any one know how this can done?
The reason for this requirement is actually a work around for a...
Hi all,
Is it possible to transfer the filter condition within metrics to a template while drilling?
I have a report which contain 3 metrics and all are set to OUTER JOIN to retain even null values.Since i am using 7.5.2 ,the requirement needs the user to click on the metric value and drill...
Hi all,
I have a requirement in order to satisfy which i need a query of the type given below:
select a.name,b.address
from table1 b
left outer join (select name from table2 where id=(Prompt)) as a
on b.id=a.id
do any one know how this can be accomplished in MSTR
Thanks.
Hi all,
I have a report in which filters are embedded into the metric condition.This report also has drilling capability to another template by clicking on the metric value(version 7.5.x).Right now i am unable to include this filter condition while drilling to new template.
is it possible to...
Hi all,
I have a huge table with 100's of thousands of rows.
I have to create a report on this table with prompts.For example allowing users to select customer names,state,city...
Now if i use this table itself for the prompt and since the customer names,state,city repeats many times, i...
I have a requirement in which the reports are to be integrated into the corporate web portal and don't want to use microstrategy web.I did some research and found out that by using SDK and Portal integration kit we can achieve this objective.
Since I have worked only on microstrategy Desktop and...
I have a requirement in which i need a subquery as highlighted below:
select gtn, btn, date
from user e
join cycle c
on e.id = c.id
where gtn = '648554807' and date = (select max(date)from user e
join cycle c
on e.id = c.id
where gtn = '648554807')
group by gtn, btn, date
Can any one help...
I have a drill hierarchy which is as follows:Director->Manager->Supervisor->Service Rep
Is it possible using security filter or any other options where a user can only view report details pertaining to him/her only?
for example,if there are 2 managers, manager1 and manager2 and if manager1...
All,
When i try to print a report from the web , it is giving me the following error.
" Internet Explorer cannot open the site http://microstrategy-pr2/microstrategy/asp/Mian.aspx.
Operation Aborted".
This is happening only for one specific report, the other reports in the project print well...
I have a text prompt where the user is prompted to enter for values.
For example if the user enters a value 123,i get the WHERE clause in sql as "WHERE value='123'" and the reports works good.
but when the user enters multiple values seprated by comma for example like 123,546,769. the WHERE...
Hi,
I have created a report Srvs Document with 2 datasets in it.It was working fine. After 2 days I changed the filters on the datasets and now it gives me the following error message.
Status: Execution failed
Error: Dataset () execution failed:
Unexpected case inside switch statement of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.