Post your Query

Please post your queries here and it will be answered.

Topics Include

1. Administration
2. Architecting
3. Report Developement

80 comments:

  1. Hello Poornima,
    I want to know what is change journal?

    ReplyDelete
  2. Change journal is a place where changes made to objects are kept track of in MicroStrategy. You can enable change journaling on a project or all projects.Its available in Administration->System Monitors->Change Journal Transactions. It stores details of all changes like new creation, or modification and the person doing the change, time of creation or modifictation of the objects. Following is an example


    Object Name: Customer Id
    Object Type: Fact
    User Name: Administrator
    Transaction Timestamp: 9/7/2012 12:36:12 PM
    Transaction Type: Save objects
    Transaction Source: Desktop
    Project Name: Customer Analysis Module
    Comments:
    Object ID A6FDAFA648F86FBAB162DFB05A06C5A9
    Machine Name: xxxxxx
    Change Type: Create
    Transaction ID: 48F3264343BA781A8014D3921F6B6457
    Session ID: EDD77DC94ACC7B1FE64441A0E3605AC9
    Link ID: N/A

    ReplyDelete
  3. Hi poornima,
    I have a report with custom group (2elements), 2attributes in row, 1 attribute in coloumn and a metric. I want to calculate the percentage calculation at row level. I.e. for single attribute the total percent should be 100%. I can able to achieve for attributes and can't for custom group. How to calculate the metric at custom group level

    ReplyDelete
    Replies
    1. Check if the below technote helps you.

      https://resource.microstrategy.com/support/Authoring/DisplayTN.aspx?tnkey=9920&formatted=1

      Delete
  4. Is it possible to move the legend to top of the graph. And Is it possible to word wrap in legends if it have two or more words

    ReplyDelete
    Replies
    1. You can move legend to the top of the graph using Graph > Preferences > Layout > Set Manual layout. This works in interactive mode but not flash mode as per microstrategy and it has been logged as an enhancement request.

      You cannot word wrap in legend but only can expand it or contract it to accomodate the text

      Delete
  5. Hi Poornima,

    I'm Using 9.2.1m S/w but when i open web it shows below error.

    HTTP error 401.2- Unathorized

    ReplyDelete
  6. Try anonymous authentication instead of windows authentication

    ReplyDelete
  7. Hope everyone is doing good!
    This is Shree, I am a MicroStrategy Consultant. I always follow your blogs about MicroStrategy and I must say that you are doing a great job and its really very helpful and thank you for sharing your knowledge on MicroStrategy.

    I have a question about event based scheduling for fiscal month from e.g. feb-2013 – feb-2015. How to achieve this using distribution services. Please share your thoughts about it and will really appreciate your inputs.

    Thanks & Regard,

    ReplyDelete
  8. In my experience, we had created event based schedules for triggering an intelligent cube after the day load is completed. We created a event and a schedule - which would be event triggered, associated the schedule to the newly created event. The service associated to refresh the cube would be associated to this new schedule. We maintained a flag in a table in the database which stores a 1 or 0 and when the day load is completed the flag got updated to 1 and from the db team, they would trigger the event and in turn the schedule would be triggered.

    ReplyDelete
  9. Hi poornima

    Im new to microstrategy, I wish to know when i click on a saved report what is the process happens in the backend.

    How data flows in Microstrategy

    ReplyDelete
  10. All of the metadata information is encrypted and stored in database tables defined by MicroStrategy.

    To help explain how the MicroStrategy system uses the metadata to do its work, imagine that a user runs a report with a sales metrics for a certain region in a particular quarter of the year. The metadata stores information about how the sales metric is to be calculated, information about which rows and tables in the data warehouse to use for the region, and the most efficient way to retrieve the information.

    As far as I remember the report gets saved in metadata in xml format.

    There is one another server called the object server which creates, modifies, saves, loads and deletes objects from metadata.The Object Server does not manipulate metadata directly. The Metadata Server does all reading/writing from/to the metadata; the Object Server uses the Metadata Server to make any changes to the metadata.

    ReplyDelete
  11. Hi Poornima,

    I want to insert HTML container in my MSTR dashboard but I cannot see any option neither in the Insert menu nor in the Toolbar to do so.
    Do we have to enable some setting in Project configuration or do we need to have some license for using them.

    Please advice.
    Thanks!

    ReplyDelete
    Replies
    1. Hi Ashish,

      "Create HTML Container" is part of Report Services and is a privilege in Desktop Designer. Go the User/User Group in User Manager and provide the access in Project access tab->Desktop Designer

      Thanks

      Delete
  12. Hi Poornima,

    How to get column names on every page of a document?
    considering your example explained i.e., column name such as year,month,daily average etc... How to get these column names on every page of a document.

    Thanks in advance.

    ReplyDelete
  13. If the grid is used as a shortcut in the document then it cannot be done but if you use dynamic text and have static column names place them in the page header section and it will repeat across all the pages.

    ReplyDelete
  14. Hi Poornima,

    I have report it has two attributes one metric when I execute report I got 2 sql Passes,and I have another report It has one Attribute 2 metrics this time also I got 2 sql passes. please share me your knowledge how sql passes are formed in MSTR It is based on no of tables or based on logical size.

    Thanks

    ReplyDelete
    Replies
    1. This is based on a VLDB Property Setting in Joins section "Base table Join for Template". Under this we have 2 options
      Temp table Join and Fact table join and the former is default option. Generally MSTR generates a pass for every fact table as fact to fact joins are expensive.
      Scenario 1:
      When there are 2 attributes and 1 metric the scenario might be that the fact table has only the id column and the description column is fetched from the corresponding dimension table and hence one pass is generated for the fact table and final pass is generated to join with dimension table. The other possibility is that when there are 2 attributes say Country and State and the metric is revenue. The fact table is at the lowest level which is state and one pass is generated with State and Revenue and final pass is generated to join with country table as they both have parent child relationship

      Scenario 2
      When there is one attribute and 2 metrics both the metrics might be coming from 2 different fact tables and MSTR generates one pass for every fact table as per the setting temp table join as its more efficient to join less number of rows instead of joining 2 fact tables which are huge.
      However you can have it as a single pass by switching to fact table join in the VLDB Property.

      Logical size is used when there are 2 fact tables and both have common attributes and metrics and few different attributes like aggregate or summary tables. At that time MSTR uses logical size to determine which table it would hit based on the least logical size.

      Delete
  15. Hi Poornima,

    when I execute a saved report in MSTR web what happens in background what is execution process.please share ur knowledge.

    Thanks

    ReplyDelete
    Replies
    1. A saved report which is cached at the project , template or report level without prompts when run checks if there is an existing cache available from the previous run and if present will produce the results from the cache.

      Are you referring to a report added to history list?

      Delete
  16. how to resolve mamy-many relationship in mstr

    ReplyDelete
    Replies
    1. To resolve a many-to-many relationship means to convert it into two one-to-many, many-to-one relationships and for this we need to create a bridge table. A bridge tables comes between the two original dimensions, and this new dimension referred to as an intersection entity or cross reference entity. It allows for every possible matched occurrence of the two entities. For example, the "many-to-many" relationship of many EMPLOYEEs are assigned to many TASKs which can be resolved by creating a new entity named EMPLOYEE_TASK. This resolves the "many-to-many" relationship by creating two separate "one-to-many" relationships. The two "one-to-many" relationships are EMPLOYEE or parent entity which is assigned EMPLOYEE_TASK or child entity and TASK or parent entity is assigned to EMPLOYEE_TASK or child entity. Whilst this may appear complex, the introduction of the EMPLOYEE_TASK child entity reduces data redundancy and improves overall database and application performance.

      Delete
  17. I am trying to use Personal Views in 9.3. I have an express mode document that I create a personal view from. When I click on the personal view in my subscriptions it forces the document to show in interactive mode. Do you know if there is a work around for the document to always render in express mode coming from personal view?

    ReplyDelete
  18. I have not explored much with personal views. But have you tried to set the document properties to run by default as express?

    ReplyDelete
  19. Yes I did and I also disabled all other available views from the document. A user on mstr forums noted that the issue does not exist in 9.3.1 but he could not test in 9.3.0.

    ReplyDelete
  20. Hi Poornima,

    I have a business requirement something like explained below:

    Location hierarchy - Territory - Region - District - Store
    scenario1:
    Selfplus one model:

    Here, the store manager have access to his store and one level above i.e., district

    Scenario2:
    Selfplus two model:
    Here, the store manager have access to only his store and 2 levels above but only the Totals will be displayed not complete access.

    We have 3 dashboards using Transaction Services feature and 3 subject areas Payroll, Sales and Truck.

    Not sure on how to arrive the self plus 2 model, we cant use security filter concept as we are using the LDAP. Can you please suggeest me like how to acheive this selfplus2 model and life how many report may be involved and what kind of metrics needs to be created etc.

    ReplyDelete
    Replies
    1. I have not worked with LDAP till date. But as per my knowledge you can implement the security filter concept with LDAP using system prompts.

      Please check this link

      https://resource.microstrategy.com/support/Authoring/DisplayTN.aspx?tnkey=35069&formatted=1

      Delete
  21. Hi Poornima,

    How/Where to display the level metrics in dashboard? Please tell me.

    ReplyDelete
  22. You can either add the created grid as shortcut in the dashboard else you can add the level attributes in group by section and place the attributes in respective group headers and metrics in the detail seection

    ReplyDelete
  23. hi Poornima,

    What are the differences between dynamic dates and transformation?what are different scenarios to use those?

    ReplyDelete
  24. Dynamic dates are dates that change constantly and are calculated with respect to the current date.They are usually created in the filter editor.
    These can be calculated with respect to week, month , year or day..eg: Today - 1 for previous day, month to date can be calculated using between clause with values 1st of this month and today.

    Transformations are business rules to compare results of different time periods. They alter the behaviour of the metric. They are of 2 types expression based transformation and table based transformations. Expression based transformation uses arithmetic operators, functions like date-1, date+1, adddays but table based transformations equates a column to another column.
    Transformations are generally used for time based calculations like previous month, previous year.
    Whereas transformations can be applied only on metrics, dynamic dates can be used in report filter or metric filter.

    ReplyDelete
  25. Calculation Server Error While Opening Dashboard Please assist

    i am getting the below error while opening dashboard in desktop and web .
    An error has occurred on this page.(Calculation server error. Metric in sort definition can not be found.Calculation server error. Metric in sort
    definition can not be found.Calculation server error. Metric in sort definition can not be found.Error(s) occurred while
    loading report: DSSSQLEngine: converting Report : Template Unit-Dimensional Metric-Dimensional Metric-Aggregation Metric ().
    -Aggregation Metric Expression-Aggregation Metric-Aggregation Metric Leaf-Expression-Expression-Object is not found in DFCSchema
    during DFC conversion..Internal Error: DSSDocumentDataPreparationTask::Run(): Error evaluate views info, job 9955, Error Code=-2147212797.)
    Continue


    ReplyDelete
  26. These errors sometimes pop up with respect to a version 9.0.x has problems. However please check the below.
    1. Confirm if the schema is properly updated
    2. If any views are involved check if the views have all the columns involved in the report
    3.If there is any inconsistency in the schema fix it using scan MD

    Check this technote as well
    https://resource.microstrategy.com/support/Authoring/DisplayTN.aspx?tnkey=15698&formatted=1

    ReplyDelete
  27. Hi Poornima,
    I want to learn MicroStrategy, i stay in hyderabad, i want to know which is the best institute in hyd to train microstrategy. Sorry this is out of subject question but please could you let me know any inputs. Waiting for your reply, Thank you

    ReplyDelete
    Replies
    1. I am not aware of any institutions that provide training on MicroStrategy.

      You can check with Aptech centers.

      http://www.hyderabadtrainings.com/microstrategy-training-institutes-hyderabad.html

      Delete
  28. Hi poornima,
    I'm new to Microstrategy. Could you please let me know how should i get into Microstrategy, who can teach it very well,Please help me.Thank you

    ReplyDelete
    Replies
    1. To start of with you can ask someone who is experienced to give a small demo. Using the project design guide and reporting guide available in the mstr support site you can advance further and then move into the advance reporting guide and other guides available

      Delete
    2. Thank you very much poornima for your prompt reply. Hope i find one.

      Delete
  29. Hello, I have a question on prompts:

    here is my issue.

    within a document I have 3 datasets, two are subsets & one is based on a total. All three datasets have the same 3 prompts, while the subsets would have an additional filter.

    When the document is executed the following prompts are listed:
    dataset 1: prompt 1, 2, &3
    dataset 2: prompt 1, 2, &3
    dataset 3: prompt 1, 2, &3

    The values required for the prompts are consistent for dataset 1,2,3.

    What needs to be changed in order for 3 prompts to be required when the document is executed instead of 9?



    ReplyDelete
    Replies
    1. If the prompts are existing shortcuts then only 3 will be prompted. However if every dataset had prompts created individually inside them then they are local to only that dataset and they get prompted for every dataset. Create the 3 prompts. Store them in the prompts folder and add the prompt shortcuts to the datasets

      Delete
  30. Hello. Is there a way I can manipulate an attribute? Specifically for a year, like 2012. How can I manupulate it to do 2012 + 1 or 2012 + 2?

    ReplyDelete
  31. Is it like in the report everytime you want it to display year+1..then you can manipulate the attribute expression + 1..If this does not help you please give me the exact scenario which you expect.

    ReplyDelete
    Replies
    1. In my report time selection prompt I select years 2012 and 2013. But when I report the time selection prompt in my document, it only shows one year. How do I make make it to display the 2 years that I selected in my prompt?

      Delete
  32. If its an element prompt and if u have the year attribute in group by section then there is possibility that only one year shows up as that may be selected in page by.
    Else check if the year attribute is placed in the detail section. A header or footer will only display one value.

    ReplyDelete
  33. For a Document:

    Is there a method for prompting user for a value that is not available within a dataset. Or allowing the user to change / edit a text box.

    Example: Client Description

    User would enter Client Description to be displayed within the Document Header

    ReplyDelete
  34. Without including in the dataset we cannot prompt a value directly from the document.You can add a value prompt of text type in the dataset and create a metric out of the same using ApplySimple and then include it in the document header as {&Promptn&}.

    However you can try inserting a html container in the document and use a input forms to add and edit a text box. However after entering or modifying data they dont get exportted.

    ReplyDelete
  35. Issue, I created a document/report & custom group in a test location. After completion:

    1) I moved all items to another location.

    2) I re-linked the custom group in the report to the new location.

    3) I re-linked the dataset in the document to the new location.

    Issue: Graphs within the document are not updating to the new location.
    If I search for dependencies on the custom group within the test location, it lists the document within the new location.

    I cannot find any properties listed for the graph that allows re-linking / changing the dependencies.

    If I delete and re-create the graph, it solves the issue but it is time consuming thus I’m looking for a better method. T

    ReplyDelete
  36. I have a report with about 5 attributes and 4 metrics. Is there a way to run subtotals for all the metrics but see only subtotals for one attribute?

    ReplyDelete
  37. In the subtotals -> Go for the advanced options and in that you can select across level and choose the attribute for which you want to display the subtotals. Hope this helps.

    ReplyDelete
  38. Hi Poornima

    Thank you for sharing your knowledge on MicroStrategy with us.
    Could you share some real time scenarios with solution, in MicroStrategy development/Architect/others that you would have experienced frequently.

    Thanks in advance.

    ReplyDelete
  39. I have a document with graphs. I tweaked the called report to add some attributes. The added attributes are not used to create the graphs. When I rerun my document, the graphs are not updated. is there another way for the graphs to be updated without deleting it and re-creating it?

    ReplyDelete
  40. Once you save the document and reopen it you should have the attributes in the new dataset. Try clearing the cache before checking for the new attribute addition. You said that you have not used the new attributes to create the graph then you cannot see them in the graph.

    ReplyDelete
  41. It's not much of an issue with the attributes but more of the custom groups. Custom groups do not refresh.

    ReplyDelete
  42. By telling custom groups dont refresh do you mean to say that the new grouping values are not showing up. Suppose you have a attribute x and metric y on your report initially and in the document you have plotted the graph using x and y. Later you added a custom group to the dataset
    and in the document you want it to show up as part of the graph. Then you should go to the grid view of the graph and add the new custom group/ attribute to the grid manually and go back to the graph view and plot the graph. But if you dont want to do this and automatically have the attributes added then you should specify in the grid properties with source as shortcut.

    I hope it helps. Please let me know the exact scenario if it does not helps

    ReplyDelete
  43. Hello Poornima,

    I wan to give prompt in the form of radio buttons. But the values for radio buttons are not in the db. How to give those values manually for radio buttons.

    ReplyDelete
    Replies
    1. If you need to have the values passed to the grid as a filter like an attribute value then you need to create a static table with those values and map it to the attribute and use the same.

      Delete
  44. hi poornima
    i have just started my career and im getting a chance to work as a mstr admin so should i go for that or ask for something else abit confused.... and what kind of challenges i'll be facing

    ReplyDelete
  45. Its better to start always as a developer working with Public Objects and then get involved in developing schema objects . This way you can really understand how the data flows into reports and then move to an admin role as you will be really able to understand how to monitor reports, if some errors occur then try to debug them by looking into log files, how to set up security and configure the I server and Projects for better performance. Admin is always a big role but it depends on what work you are going to perform if its at a lower level or at a higher level.All the best.

    ReplyDelete
  46. Hi Poornima, I want to create a report where I need to select two dates using prompts. The Dates will be Date From and Date To. Before finishing the report, I want to validate the values of selected dates and in case if the Date To is smaller than Date From, then wanted to show custom message to the user to correct the selected dates. Please suggest

    Regards,
    Ajeet Singh

    ReplyDelete
    Replies
    1. Create a from date element list prompt.
      Then created a to date filter where the date value should be greater than equal to from date. When you define the to date prompt, in the"reduce the number of elements available to the user at runtime" section use the newly created filter to filter the to date

      Delete
    2. Hi Poornima, thanks for your quick response and help. The solution is working in scenario when I am selecting From Date from a Date Value Prompt and using Element attribute list for a To Date prompt and putting the restriction using filter. However I need to use Date Value prompt for both the Date selections and want to restrict the min value of To Date based on the From Date input value... Is there any way to decide the min and max value for the value prompts using filters?

      your help

      Delete
  47. Hi Poornima,

    I have recently started working on Microstrategy and got stuck up with an issue. I have created an attribute element list prompt where I have set all the existing item as Default prompt answer. But when my data in the warehouse is updated, then the prompt is showing in correct default values. Is there a way to dynamically update the default prompt answers when the data is updated in warehouse tables?

    Thanks,
    Vipin Pal

    ReplyDelete
  48. Yes the element prompt answer is designed this way. The default prompt answer does not go back against the warehouse when resolving a pre-defined prompt answer or default answer. The only way is when a new value is added in datawarehouse you have to go and add it manually and save it as default prompt answer.

    ReplyDelete
  49. can we apply thresholds to attributes or only to metrics

    ReplyDelete
  50. Thresholds can be applied only on metrics

    ReplyDelete
  51. Hi Poornima, I will be grateful for your help regaring MSTR, I am following and completing the work by your answers.
    thankyou

    ReplyDelete
  52. HI Poornima ,
    Can You share with me, some 2 or 3 issues.What you have faced while working with 9.3.0 version

    ReplyDelete
  53. You could look at the section "Bugs in 9.3" in this site.

    A recent issue I have faced with 9.3 is that the bursting does not work with prompted documents. Only documents with filters can be bursted.

    ReplyDelete
  54. Hi Poornima,
    This is with regard to Microstrategy web SDK customizations for validating prompt answers. I have pasted reportPage.js to this folder :
    Program Files (x86)\MicroStrategy\Web ASPx\plugins\ValidatingValuePromptAnswer\javascript\reportPage.js and placed custom jquery code for start date and end date validation.
    Now when i run the report, then reportPage.js gets loaded and custom validation works perfectly. But when I run document referencing this report, then reportPage.js doesn't get even loaded due to which custom prompt validations are not working. Please suggest what extra configuration needs to be done for loading reportPage.js in case of document also. Fast response will be highly appreciated. Thanks in advance.

    ReplyDelete
  55. Hi Poornima,

    It will be great if you help me out in this situation. I have 2 tables let's say Table1 and Table2. Now MSTR report should display records from both the tables. Both the tables have same structure with regard to column names and data types. So in short we need union of records to be displayed from both the tables in MSTR Grid Report. Any help with this regard will be highly appreciated. Thanks in advance.

    ReplyDelete
  56. Ideally there should be a difference between both the tables data. Union would be a full outer join. The attributes created out of table 1 and table 2 should be having common attributes but if the metrics are different then you could select the metric join type to be outer and have a full outer join which would bring data from both the tables.

    Another scenario is something like this say Fact table A would have country A's data and Fact table B would have country B's data, then a partition mapping could be created with Country= A and Country = B as slices and even if metrics are common then mstr would be doing a union between both table's data.

    If none of this is feasible, then go for creation of a logical view with a query that union's both tables.

    ReplyDelete
  57. all users did not get read/write access to their corresponding My personal objects folder please suggest me what went wrong and how to fix it.

    ReplyDelete
    Replies
    1. Check if the privilege web save to my reports is enabled for the users

      Delete
  58. Hi. We had formatted the client system and then we reinstalled the client. Then on wards, the reports cannot be edited (even View SQL) does not work with error "Type Mismatch". How to fix the same?

    ReplyDelete
  59. Try the following
    1. Restarting the machine after installation
    2. Check the dsn connectivity
    3. Updating the schema.
    Check your client machine configuration like if it's 32 bit or 64 bit and if it's compatible to connect to server

    ReplyDelete
  60. Can you please explain me what is the Grouping parameter used for in Metric?

    ReplyDelete
    Replies
    1. Grouping decides what attribute appears in the group by clause of the query. When grouping is set to none , it ignores the attribute and its childrent in the group by clause.
      To use the first value of the lookup table, select Beginning lookup.
      To use the last value of the lookup table, select Ending lookup.
      To use the first value of the fact table, select Beginning fact.
      To use the last value of the fact table, select Ending fact.

      Ideally for inventory metrics, we use last value of look up table, otherwise called ending lookup

      Delete
  61. Hello , I am using month attribute to create min month and max month metrics and the output format i am getting is not correct , How can i use passthrough functions to get the correct format. Your help is greatly appreciated. I am using prompts to select min and max months . following is the format

    Metrics Min of Month Max of Month
    Month
    Jan-2012 Jan Nov 2450 Nov 2450
    Feb-2012 Feb Nov 2450 Nov 2450
    Mar-2012 Mar Nov 2450 Nov 2450
    Apr-2012 Apr Nov 2450 Nov 2450
    May-2012 May Nov 2450 Nov 2450

    ReplyDelete
    Replies
    1. Hi, Please let me know the reason why you need to use pass through functions for the same? You can apply custom formatting on the metric - "MMM - YYYY"

      Delete