Scenario:
Medical Background:
Dimensions tables : Provider, DRG, Type of Service, Member, ICD9 Codes, Line Of Business, Age, Time.
Fact table: ClaimInpatientFact, ClaimOutpatientfact, ClaimPharmafact, Memberfact.
Granularity of Data: Month level.
Challenge: Decision to have the Age...
I have a requirement where a prompt which was created
based on the date attribute with a " between "
operator has to display its values side by side in
desktop and it also has to display side by side in the
Web instead of the default display of one below
the other...
I have a requirement where the business wants to allow
only certain users to login during peak hours (between
8.00 a.m to 11.00 a.m)everyday. So I have to restrict
the login of certain users into MicroStrategy.
Do anyone have an idea of how to restrict the user
login for...
Just wanted to find out the various data warehouse implementation challenges that others are facing out there. Please share your experiences.
thanks
teccum.
I am trying to configure the LDAP Authentication for the group of users.
I have imported the users from the NT domain and have defined the Group Distinguished Name in the Authentication Tab of the Group editor.
when I try to logon, I am receiving an error message like
"(MicroStrategy...
I am trying to create a metric involving MOVINGAVG ( moving average function). I am not getting the right answer when I use this in my report. I tried creating Moving Average from the Tutorial Project using the "Revenue Metric" as the value and the window size as 3. My report contained the Month...
I need to create a filter between two different time values.
Actually I need to substract the "claim service start date"(which will be user prompt) and then compare it with "Cap Pay Month" (which will be a user prompt of Month attribute - Actually here Month Id is linked to the Cap_fact table...
I need to create a report where a part of the data is from the excell file. Basically there is a report which has columns - Budget, Actual(claim net amount for all line of business(LOB) - available in the database), %Over/Under(Total claim amount /claim net amount for a particular Line of...
I need to create a time difference column in my report. Actually, I have to create an attribute called 'Out Of Compliance'. The formula for this is
(Claim Received Date - Claim Paid Date) > 60.
I have created the derived attribute for Claim Received Date and Claim Paid Date by giving the...
All,
When I try to access the elements through the system Hierarchy, I get an ODBC error. My datawarehouse database is SQL Server 2000 and I have defined a ODBC DSN in my computer pointing to the datawarehouse database (datawarehouse DSN)in SQL Server and I have created a database instance...
I am not able to open the Service Manager so that I can start and stop the service from that. Instead I am doing it through the Windows Services.
When I click on the Service manager, it is not initialising or opening and does not return a error message, but the mstr service is running.
Is it...
When I try to login into the Web Adminstrator through the Program files --> Microstrategy --- > Microstrategy Web Administrator. I am also able to login through the link in the Web login page where it say's "Go to the Administration Page".
It allows me to the web administration page without...
Hi,
I am working on a Healthcare datawarehouse and have few modelling questions.
I have a claim dimension which has four different types of date fields. That is there is claim service start date, claim service end date, claim paid date, claim received date. I would like to know how to treat...
Hello,
I configured the mstr I-Server and then tested it by moving the Mstr Tutorial project into 3 tier by moving it to I-Server. I was able to access the project from another desktop but when I tried to execute the report I get a ODBC error. I am wondering where I am going wrong...
Hello,
I installed Mstr Web Analyst edition of MSTR Web in a server(SQL Server) which has five partitions. I installed Intelligent server in one partition and Web server in another partition. I did not get any errors and the installation got completed successfully. I checked the Intelligent...
Hi,
I could not run my report and get an error or warning like
"Hour must be between 0 and 23"
for my formula calculation.
My formula for Y is
Y = Time (Truncate ({@X}/60), Remainder ({@X},60),00)
My formula for X is
((ToNumber (left ({CDMAB.TIME_IN}, 2))) * 60) + (ToNumber (mid...
Hi all,
I am trying to run a report. I can see the crystal reading the data with the help of the menu bar at the bottom of crystal, but could not view the data and get blank report.
could some one tell me what can be the problem of the report.
thanks
tecum
Hi,
Could someone give me the exact difference between the target table options in the session, Such as Insert, Update(update as update), Update(as insert), Update(else insert), Delete, Truncate table.
Even though info is given in the help file and I understand to an extent. I would like to...
HI,
My project is currently in ver 6.x and the database which we are using now is DB2(we have recently migrated from a different database). Now, what are the settings should I change in project file or dot DSS file of each project with respect to the DB2 database and also what are all the...
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.