Eazybi cube. CurrentMember,[Jira Issue].

Eazybi cube I have 2 questions. Here is what I found: The following page which discusses how to augment Our JVM heap size is 8 GB Is the query error causing the Out of Memory error? What are some options for resiolution? From our logs 2018-04-19 10:05:04 -0500 ERROR Could you please help with labels import from CSV to separate data cube I’m trying to map Labels columns as a unified dimension and Measure/Level, but after importing to EazyBI I’m not able to see all my labels when analyzing the data in the report. Some help on learning MDX would not go amiss either. The training videos are based on data from Jira: there are a few differences in account creation and data imports, as well as some sharing options available only for the Jira app. Data import creates the multidimensional data cube and ensures that imported data is organized and stored in a more report-friendly structure. Hi @Purnendu. With eazyBI you can find all the assets with an overdue warranty. Imported data are organized in tables and relate to each ot See available source applications that eazyBI is integrated with. . [eazyBI_Markdown] Markdown You can use Markdown formatting to show a rich text (bold, italic) or Here is a report example with this formatter in our demo account. Table was imported into Issues cube, but I do not get a handle on how to map this imported data to jira data. grantina December 8, 2023, 8:51am . In “Rows”, we have Did you consider option not to import these issues in the eazyBI at all? Please note the JQL filter option in Jira import options screen where you can define which issues should be imported (and which shouldn’t) in your eazyBI cube. If you list your assets based on assigned service tickets, you'd find the most faulty ones. If none of the issues has the status “Atendimento Core”, you won’t find this member in “Status” dimension list. On the Server and DC version before 7. For example, the Jira Issues cube has Age interval dimension which contains time intervals of unresolved issue age (time between the creation eazyBI might mark measures as invalid if the dimension is removed from a cube with the import. We use Advanced Roadmaps in Jira. Create reports. eazyBI detects if a file has a header row with column names [2]. Best, Marita // support@eazybi. All the 5 boards are very similar, only “column” settings change between them, typically Transition status in Done column. The root cause seems to be related to the “Config” member in the dimension. For example, import planned start period as string, program Use eazyBI usage statistics to identify these reports, focusing on those with the highest failure rates and longest execution times. They want to keep the MDX: Going Beyond 3D Reporting in Multi-Dimensional Data Cube. Learn More. If you have more than one cube in your account, Hello Eazybi, Due to the immense growth of eazybi at my location, a full import is not possible during business hours. As a newbie I am struggling to understand the Data Cube in eazyBI for JIRA. I tried this: Define report specific calculated member formula [Measures]. I am trying to import a file that provides additional measures for those resource group options. Hi everyone! 💫 For eazyBI for Jira Cloud users with Organization or Product admin rights in your Jira instance. Answer. We want to count number of specific value of “Closed Reason” over time interval. To display a number of issues in historical statuses over time, we recommend importing issue change history Hi everyone, I’m doing some data mapping by importing data from an MS Excel file into a new Cube. In the table view, click on the measure header and choose to Drill into → Xray → Xray Test Type → All Xray Test Types to For each event, eazyBI displays the eazyBI Account where the event happened, which user performed the action, what action was performed, when this occurred, what type of object was changed, and the object itself. BR Dirk. However, you can analyze and visualize cube data effectively using eazyBI’s built-in report Starting out or looking to deepen your expertise with eazyBI? This guide walks you through the essential steps and tips to elevate your eazyBI knowledge and create impactful eazyBI assistants combine the leading LLMs (large language models) with the data from eazyBI documentation and sample data cubes and reports to answer questions about eazyBI, build Powerful MDX formula editor with built-in functions, calculations, auto-complete. Do you by any chance remember what the problem was and how you addressed it? After that, open the eazyBI database migrator in the new eazyBI installation and select the option to migrate data from another database into this server [1]. These dimensions will remain in the eazyBI cube but Hi folks! The following attachments are the exported definitions to create the sources and the reports and dashboards to have the data configurations of Jira that were presented in the eazyBI Community Days 4) corrupted eazyBI data import. CurrentMember, [Issue Close Date]. When I tried to just put Issue Close Date in rows and turn on the Raw Lead Time metric, this is what I got: Then I made a calculated metric Lead Time: Avg( Descendants([Issue Close Date]. Label2 should be changeable so i putted the Label Hi, I have 2 sources: an Issues cube generated from JQL and the simpliest . It means that besides eazyBI accounts with data from Jira, you can create a separate account solely for data from an external source. Can anyone point me to some clear documentation. I hoped I could use definition Hi Team, We are getting this error Formula is not valid: MDX object ‘[Xray Test Execution]’ not found in cube ‘Issues’ , When we pull multiple projects Xray Welcome to eazyBI community. The first thing to try is to empty the data cube and reimport all issues to realign data with Jira in case of failed import. Though, you may place reports from all the cubes in one eazyBI dashboard. Select which Jira projects you would like to import in eazyBI. Hi, Jacques. Store additional and advanced settings Hi Jacques, I did a bit deeper investigation and come up with a solution for data import from Bamboo. Each detailed cube “cell” contains sales amount and units sold for a particular product, customer and time period: It is easy to illustrate cube with three dimensions but you can have as many dimensions and as many measures as EazyBI - How to filter to see a subset of a dimension with labels. You can start creating table reports by dragging needed dimensions to columns, rows, and pages and exploring your data at different dimension levels. If the Time dimension is used then Tickets created are grouped by ticket creation dates and shown in a corresponding time period. ; Xray Tests created is a default eazyBI measure for Xray that represents the count of Tests assigned to the Test Plan. Dashboards and reports visible to non-Confluence users. eazyBI in Confluence pages. In the Rows section I added Time, and I made a filter to show issues between 2 weeks ago and today. CurrentHierarchyMember}, [Measures]. From my tests, i notice that the setting up of the template-recipient relationship (go to Import options screen > Additional options, and select one of the available template accounts) is only available when i eazyBI imports the following Zendesk data (measures) and dimensions: Tickets data cube measures. That’s why I want to be able to filter them by status. csv to Issues cube? Like in this (generated) picture P. For a while, the user interface and usability questions have been neglected; not anymore. I have imported issues from JIRA into eazy BI and for each jira project I want to add Hi, @Amzad Sorry for not catching the reason at first. Best, Ilze / support@eazybi. Create eazyBI dashboards. 56 1550×1130 130 KB. I have built the table below, I just need an average column added to it. Dive dee We do have a feature request to add “Watchers” list to eazyBI cube in the future versions of eazyBI but I can’t share the release date for this feature yet. Another option: just create reports in two cubes (the same account) and display them side by side on the dashboard. But Hello, it’s my 1st day in EaszBi and I am playing around with default report “Unresolved issues by age interval and priority” It shows age intervals using (I assume) CreateDate as a time reference. 0. Instead of importing your date picker Jira field as a separate dimension, it should be enough to import it as a measure and property , and then use the numerical measure "Issues with " with the “Time” dimension Unfortunately, worklog field items can not be imported in eazyBI cube if you use Tempo and Jira Cloud combination to log hours in Jira. Fixed expansions of visible measure groups when filtering by name is used. The report should show the result for You can enrich the Issues data cube with additional data from external data sources, like files, REST API, or SQL SELECT to a database. When I build reports using data from source file, this functionnality is not available. Hi, I’m a newbie in eazyBI and have (maybe) very basic questions, but I ask for your help. [Issue eazyBI uses API keys to get data from Xray Cloud. On closing an issue, we add the reason for closure. For example, you can upload a Git commit log as a file source to eazyBI and import it into a separate cube. 1 Like. Secure, scalable, robust built to scale to large data sets without As a newbie I am struggling to understand the Data Cube in eazyBI for JIRA. The corrective actions in each situation depend on additional factors. This is a radio-button field in jira. New to eazyBI (and cube reporting in general) so apologise in advance for dumb questions!! A customer of mine has a graph already created which shows bug count over time to show resolved etc. We have imported Jira issue data from jira eazyBI for Jira is a general-purpose Business Intelligence tool. Each eazyBI account is a data warehouse with a certain structure based on the data you import. In Jira Cloud, go to section Apps → Xray -> API Keys and create API key. It would be very difficult to keep track on all those project by few EazyBI admins. Cubes. I need to generate a single report with the data All eazyBI for Jira eazyBI for Confluence Private eazyBI After importing data from source files or source applications you can go to Analyze tab and start to explore data in the data cube. I don’t understand why I only retreive 2 of the 5 boards when browsing though Sprint/Boards dimension. You can enrich the Issues data cube with additional data from external data sources, like files, REST API, or SQL SELECT to a database. I can get the pictured eazyBI does not have technical limitations for issue count in accounts. Tailor eazyBI’s functionality to specific business needs. Watch. But it is possible to import additional data to the Jira Issues cube if there is some linkage between data; see the documentation here: Additional data import into Jira Issues cube And some training videos here: Data Mapping from Other Data Sources Hi, I am trying to understand how the Total Resolution Workdays measure which is inbuilt is generated. eazyBI stores its log files in the Atlassian product (Jira or Confluence) There are two types of measures, predefined measures (created by the eazyBI app) and calculated measures children, and siblings for any data entity; therefore, it can travel across data in a multidimensional data cube. CurrentMember,[Jira Issue]. Average resolution workdays is obtained by the below formula (where Total resolution workdays is I have a report that I want to be able to order the sprint by start date with the latest sprint first but when I set the sprint to order it does not change { “cube_name”: “Issues”, “cube_reports”: [ { “name”: “Appl Hi, good afternoon, I’m new to EazyBI reporting. Some help on learning MDX would not go You can enrich the Issues data cube with additional data from external data sources, like files, REST API, or SQL SELECT to a database. Retrieving measures from cube. Imported data (from source applications) are not sent to external LLM services, Thereby they can not be used in the same reports (reports are created within a cube). [Raw Hi, I’m trying to import additional data (REST) into the Jira data cube, but somehow EazyBI cannot map the user field from the JSON to the Assignee dimension. It goes into a cube Running into this same problem now. In eazyBI, you can import additional data into the Jira issues cube. Hello, I have a Jira Scrum Project with currently 5 scrum boards configured. Create charts. I need to limit the data shown in my cube based on the creation date of each issue, but I need to show only the issues created in the When I imported my data, into my cube, I had several fields that I can choose as Dimension and/or Properties. Like Seth Grandeau likes this . However, the principle remains the same - it iterates through all issues imported into the data cube. CurrentHierarchyMember), [Time]. My customer Hello, Could you please add option to set Cube import period by Cron Expression, similar to JIRA filter subscriptions? I would like to get data every 15 minutes but just during our business hours. I would suggest replacing this calculation with a tuple of the Resolution dimension member and the measure You may disable data analytics from the user perspective who created or worked on the issues by eliminating data in dimensions Assignee, Reporter, Transition Author and Logged by. We have a custom field called “Invoice Type” to indicate whether or not an issue is chargeable of nonchargeable and some other options. The reason for this is that your Cloud site does not have Xray dimensions and measures. If you have a particular use case, it would be better to discuss it in a support email. To master custom fields, start by: Building your own data cube from scratch. However, you can analyze and visualize cube data effectively using eazyBI’s built-in report editor and analysis tools. For example, if the SLA is 10h and 3 hours have passed, then the remaining percentage should be 70%. I was wondering if it’s possible to have additional levels as shown in the image eazyBI for Jira Cloud is always up to date. Calculated measures and members. For certain purposes I would pref Hi @Kateryna_Nakonechna and @SAM2022, Creating a report from two separate data cubes won’t be possible. Page views counter will And eazyBI collects data starting from the moment when eazyBI account is set up, and Space is selected for data import. eazyBI recognizes the Git commit log data structure. What I want to calculate is a measure that will give me the total of all the rows in that report. A tuple uniquely identifies a slice of data from a cube, and it represents a single data cell if all dimensions are represented. The eazyBI JIRA Issues cube has the predefined dimensions for the user groups (Assignee, Reporter etc. See the list of features here: New in this release: AI assistants for building reports and writing MDX formulas are available for all cube types (not just Jira Issues). Go to the eazyBI tab Dashboard and choose the option Create a new dashboard or New. , if I have two “identical” jiras in terms of structure, can I pull them both into the same cube for a consolidated report? Further, could I still enable drill down and drill through back to Hi, I am quite new to EazyBI so maybe my question would sound silly anyway I need to move forward so I am trying to ask experts because I haven’t found any solution yet. Publish Reports. Thanks. I upvoted the feature on your behalf so you can be notified when the Hi team, We are trying to import some REST data into a separate eazyBI cube (so, right now, not linked with Issues cube for the purpose of this question), but we are having an aggregation issue I will try to explain. When using eazyBI for Jira, default user dimensions like Logged By, Assignee, Reporter, use CurrentUser function which returns user key as user name and user key do not match for these dimension members. The problem is that in the data import Do not allow empty or delete a cube while a data import is in progress. Pedriel July 4, 2023, So far, our main priority has always been the core functionality of eazyBI. Page views counter will Hi, I currently have the following setup: Columns: Measures - Issue History and Transition Status - several statuses. As Bamboo projects, plans and other information aren’t tightly coupled with JIRA Projects and versions, the best would be to import it into a separate eazyBI account. Upon closer examination of the report definition, it appears that “Config” is defined as a loop to itself: Unlock the power of data with eazyBI – a versatile analytics tool designed to help you Analyze, Visualize, Explore, and Share insights effortlessly. I would like to run this at a scheduled time over night. I understand how they are used, as dimensions, but I’m not clear on how I use them as properties. Thanks in advance, jl Hi, I’m having trouble showing linked issues from an Assets Cube. Fixed in this release: Fixed support for custom EAZYBI_PREFIX in bin/start. More on this in our documentation: Git commit log. I’ve found just case with mapping . Still, you can create a new eazyBI dashboard where you put side by side a report build on Jira data as well as a report build on application data. You can import issue links in eazyBI by using advanced settings for custom fields. Did someone If eazyBI can not detect the owner or authorized import user, the notification will be sent to the technical contact registered for the eazyBI app license. Can I have one EazyBI cube pointing to more than one data source? I. There are generally two options to show issues created in each month and year as rows and columns 1) You might put either each month or each year in a separate measure to Hi, is there any way to hide the drop-down which have been createdbased on the selected dimensions as pages? In my case the selection are very reduced and to condense the tables I’d like to hide those drop-downs if the report is However, this formula will count only those releases that have any issues associated with it. Then specify the database connection parameters to the existing eazyBI database The eazyBI data cube only has one Time dimension. If you ever wonder if you are using all of the Issue Types and Issue Type schemes in your Jira and would like to find the unused ones, here’s a rather simple solution that will result in dashboards like this: Disclaimer: In instances with a large number of Projects So I have two issue types called Event and Funding where these two issues can be linked by is funded by / Funds link types. If eazyBI has detected it eazyBI imports the following Zendesk data (measures) and dimensions: Tickets data cube measures. Yes, that’s the drawback of the drill_through_non_empty annotation - it only shows the issues that had some activity in the selected period, not all that was in the status during the time. Our general recommendation is to have up to 100K issues per account. If a release is not attached to any issue in your Jira, then eazyBI does not import it, as most of the Jira data are extracted from the @Amzad,. dataimport. This data is called capacity. I want to make a report on the status of features/enablers with all underlying epics and stories. The Capacity data I want to show in relation to the Sprint. I’m frequently updating the Excel files, which have to be re-uploaded and their data has to be re-imported. Learn how to enable usage statistics on your Jira here. How would I get the average story points resolved by assigned over the last 5 sprints? I am new to eazyBI and measures. sh. The additional data, in your case Google Sheet, needs data that can tie it together with Jira data. URL property in custom data cube. Hello, I am creating a new cube using custom fields as dimension. However, the eazyBI main concepts and Hi, I want to to build a report that will display the remaining SLA percentage for “Time to first response”, “Time to resolution” and “Time to resolution(OT)”, all this SLAs already upload as predefined measures to eazyBI. 14. However, I only want to include the features/enablers that are being worked on in the current PI. Dimension eazyBI assistants are a new experimental feature that is constantly improved based on usage statistics and user feedback. This could be very extensive in bigger JIRA instances (for example 30 new projects in past 24 hours). I would like to merge both tables into 1 new table + add a calculation column to this table (for example divi eazyBI - Understanding the Data Cube . Getting Started Private eazyBI. It would be worth checking if this is the case. Listed values - issue statuses, You can also import a new file in the existing data cube to add a new data set or additional data – in this case, select the existing cube name. eazyBI is a non-real-time analysis tool, which means that data are imported from the Source system into the eazyBI database once or regularly, First, you might want to import criteria for grouping sprints as a property using additional data import: Additional data import into Jira Issues cube - eazyBI for Jira. The new data will automatically be reflected in your reports and dashboards after the cube is reloaded. ) but the data in those dimensions depends on the user activities performed with the JIRA issues and Data access roles are available on all eazyBI products; however, if you use an eazyBI. Please at first read about eazyBI cubes, dimensions and measures as well as the eazyBI Jira data model - you will need to understand the multi You may want to look into the option of Git commit log analysis in a data cube, separate from Jira. If a user has a data When this field type is selected and imported as a dimension, eazyBI creates a new dimension with two hierarchy levels where the value from the first list is in a higher level and value from the second list is in lower level. Thank you boblewis eazyBI might mark measures as invalid if the dimension is removed from a cube with the import. The cube empty process and data refresh start could be separate processes, or together. Any guidance on when a cube is too big? eazyBI Community How big can a Cube be? Questions & Answers. When I train attendees on custom fields, I like to give them a simple exercise: building an issues data cube from scratch. We use fix version field to tag stories to programme increments and also releases. During data import to eazyBI, Jira issue information is reorganized and grouped into that structure. 2 recently. We have some clients who have accounts more significant than recommended, but those accounts are carefully tailored: Hi! I have a cube with following column mappings: I want to build a report on the dynamics of average lead time. In eazyBI, you can create one or several accounts. The report could look similar to the one below: Screenshot 2020-11-13 at 15. Best wishes, Elita from support Hi, Am a newbie trying to learn EazyBi features. I have found some information which at first seemed to be helpful, but I’m struggling to put it all together. I’ve searched and tried several things, but cannot seem to get it right. We have a number of growing projects in one cube. Steve Brown October 24, 2017 . I was able to enable the “Got to source” but not the Interval dimensions contain members that are intervals of some numeric attribute. com cloud account, it is required a PLUS subscription plan for this feature. If you need help designing reports, I recommend exploring eazyBI’s documentation for guidance. In “Pages’”, we have added “Closed Reason”, and highlighted Select members -> “All Closed Reason”. You may analyze and visualize data from Jira and Jira apps as well as from most popular SQL databases, REST API data sources, Google Sheets, Excel, and CSV files. 49. So those seven issues had some transitions in the period, while the other 48 were just in status and had no transitions. Fixed DateAddDays and DateAddWorkdays to work correctly with daylight saving time changes and additional non-working days. All numerical values like created or resolved issue counts and original estimates are imported as Measures. You won’t be able to get those data in the same report with Jira data. By default I Select application import options. I am trying to use the file import to import an excel file that has additional data for our Issues cube. I tried pretty much every combination of user key, name, display name as input and key or name as advanced setting for the Assignee dimension in the import definition. A helpful new feature is the ability to schedule an automatic empty of the cube, and full refresh. gerda. The field is currently being Another example would be finding the current user in the new user-picker Jira custom field once it is imported in eazyBI cube. Xray data import is currently available only for Server, see Xray Test Management - eazyBI for Jira. jeffscudder October 4, 2022, 1:02pm 1. 3. I tried pretty much every combination of user key, name, disp Hello all, I’m trying to import additional data for sprints. Is there a way to automate this process to avoid manually uploading files and importing their data? Thanks. The calculated measure “Total estimate hrs of resolution” uses the Descendants() function, which iterates through all the issues in the cube. LinkedIn; Hi, Did you consider option not to import these issues in the eazyBI at all? Please note the JQL filter option in Jira import options screen where you can define which issues should be imported (and which shouldn’t) in your eazyBI cube. An event has Country, Number of Leads and due date information meanwhile the Funding has only the funding amount information. I wanted to let you know that we have released eazyBI version 7. The Transition status becomes available once you have e selected to import Issues history into the Hello!! I have a demand to build a report (Table) with issues from specific project. I have imported all these projects to EazyBI cube. In Key I put in the sprint id, in Capacity an integer value. Only 2 of those boards are loaded into EazyBI cube. For this in-depth assent analysis allowing you to dive into your CMDB, Did you know that you can analyze eazyBI with eazyBI? eazyBI Wrapped is exactly that! In our “language” we call it usage statistics and it shows how eazyBI has been used in your organization. csv Before you analyze data, you need to import that data into eazyBI. Unfortunately, from the available information, it is hard to guess from the available information, which part of Jira you could tie the candidates to. Another burn down is populated with the most recent sprint for that Hi, I am currently evaluating eazy BI and I have a requirement to add more data (new data) to the cube and facing some issues with it. When a category for a project is changed in Jira, the project eazyBI gathers data via optimized API requests to collect data as quickly as possible with minimal impact on Jira performance. Issue linking in Jira is a powerful option and is widely used. Dear eazyBI-team, I would like to filter my Measures (created Issues) according to two different specific Labels. Exported report definition will also include all calculated member definitions that are used and needed for this Hi Team, I have 2 tables with some data (different queries result), with Epic ID as the key of both tables. At present I have 1 hierarchy level. Instead of using standard Zendesk data import, you may import some Zendesk data as additional data into Jira cube using REST API, SQL select or CSV. So each item in Jira will be tagged to at least 2 fix versions. In the eazyBI, you can create one or several accounts. Training videos. com board items that you would like to analyze. [Issues with Watch step-by-step training videos on how to get started with eazyBI: main concepts, data import, report creation, chart customization, and, finally, sharing reports. documentation examples, sample report examples, and metadata about cube measures and dimensions, are sent to external LLM services. Please make sure that there is at least one issue Accessing cube data directly in SQL or OLAP editors isn’t supported in eazyBI. Now it’s important for us to see when this field value was changed and preferrable from what, to what. Analyze & Visualize. You can select all or individual projects and hide unselected ones, as well as clear selection [1], use the search filter to find your project [2], and even choose between projects and categories when selecting data for import [3]. I will put a simple example to show the problem, though the data we have is much bigger: domain product component myMeasure domain1 productA And eazyBI collects data starting from the moment when eazyBI account is set up, and Space is selected for data import. If you do need the data immediately you could kick-off the import manually, I create a Template Account based on a SQL source application (not a Jira source application) mapped in a custom cube (different to the default Issues Cube). Ultimate goal: have a shared Pages filter on a dashboard where board is selected, then a burn down chart is populated with the active sprint for that board. Cubes contain fact Accessing cube data directly in SQL or OLAP editors isn’t supported in eazyBI. Start by warming up with the basics of retrieving data from a multi-dimensional data cube. I’m using the standard measure “Issues created” and a custom measure like Generate( Filter( Descendants([Jira Issue]. [Day]), [Measures]. I want to see how many days/hours/minutes between issue created date and issue closed date. I use the function li eazyBI data cube of Jira issues can help with some use cases for the Jira administrators but is insufficient for more advanced cases. 0, adding back the dimension will not remove the invalid marker. Enter the name of the dashboard [1]. com The eazyBI data cube is made up of Dimensions and Measures. Create a new dashboard. Best, Roberts // Hello, I am trying to add additional metrics of cumulative target story velocity by week to add to some existing Jira reports in eazyBI. For Hi, When I build reports in EazyBI using the Issues cube which comes with the Jira Application source, there is an option to “Drill Through Issue ”, which basically gives the ability to display a list of all the issues that comes under the selected criteria. That could be the limitation in your use-case. Analyze Jira, JSM, Marketplace apps, DevOps, SQL, REST, CSV, Excel, and more. If there will be new project/category in JIRA, I will have to manually update the Cube setup. No, you don’t need to make any changes to dashboards or Confluence pages when a cube in eazyBI is reimported or updated. For the S-Curve calculation I need to supply a start and end date not based transition starts or resolutions dates as in the eazyBI example S-Curve, but on dates given by the development effort itself. That would decrease the number of issues in your cube so all the reports would be faster. For the API key, select a user with Jira administrator rights. This dashboard might not be the most serious one, but definitely gives an overview of what is being used the most while using eazyBI and might bring some ideas on I have a project that has epics with a “Works with” link to feature issues. On this page: select one or several cubes from the list. If you need to use those measures, import the dimension back into the account. Just refresh the page to see the latest data. The associated data is loaded into the used eazyBi cube. I have 5 different teams in my programme and each team uses its own Jira Project. com Therefore measure “Open issues” may not give you expected results when “Status” dimension is filtered. com) there is one account per subscription plan. I read this post which seems close but I’m not understanding how to apply it. In this article, I will try to explain how to set up and import issue links in eazyBI. All teams use same nomenclature for fix version (for releases R1, R2 etc and for The eazyBI data cube is made up of Dimensions and Measures. Hi @Leon,. During the import, the data is transformed into an "analytical OLAP data cube", a data structure that Additional data import into Confluence cube. [Issues closed]) ) When I use My customer want to know what is too big for a data cube in eazyBI. Page views are updated every hour on Confluence Cloud and every 10 minutes on Confluence Server. The Cloud version is available for customers who are willing to participate in beta testing. By default, eazyBI will add a new dashboard as the last one, but you can drag a After creating an eazyBI account, you need to import into the eazyBI database selected monday. There are certain restrictions for “Issues” cube that is being created when you import data from Jira into eazyBI. But it may vary on imported data and how you are going to use those reports. If you are defining any I’m using the SQL Application to fetch data into EazyBI. Hi, I’m creating a new EazyBI Cube containing data which is mapped by uploading Excel files. Field “Closed Reason” can be “Software”, “Hardware” etc. How can get age intervals using a custom date as I reference? I would like to see issue due by age interval since issues were 1st picked up and moved to Hi everyone, i’m working on eazybi reports and i have a little problem with DateDiffWorkhours function. The colums of this reports are symple like Issue Summary, RequestType, Assignee, Reporter, Resolutions Date, etc However, the user See if the Sprints that shouldn’t be in the eazyBI cube have a value for the calculated measure. Account → Source application → Data cube → Folders → Reports → Measures → Dashboards. when the data cube was created, workspaces and boards imported in this cube, and a You will see the report definition in JSON format, please copy this report definition for pasting it in the other eazyBI environment. csv to append to Issues cube Is it possible to append/push data from . My goal is to create two reports within a specific period of time by filtering the Event’s due date: The total Background information: I’m using an API pull from our Gitlab instance that gives me dates for merge created, closed and merged along with number of comments, ID, MR number, IID, and Project. Demo accounts. In the case of eazyBI cloud (eazyBI. Tickets created: Total number of created tickets that matches selected dimension members. I want to add this link to my EazyBI cube for reporting. 0, adding back the Please at first read about eazyBI cubes, dimensions and measures as well as eazyBI Confluence data model - you will need to understand multi-dimensional data model to be able to map new source data columns to cube dimensions Is there a way to add the “Display Name” functionality to members of a custom cube? My cube has problem records and I added fields for Key, Summary and URL. Time required: 20 minutes. The main reason your report is slowing down over time is the growing number of issues. Measures are numeric values or metrics in the data cube. I have a report which needs to determine the average resolution workdays however having an additional condition measure field (Send Confirmation Date). One of such restrictions is that you can’t create new dimensions form additional data. [ NoTargetCompletionDate ] = IsEmpty[Measures]. So I defined an excel table with columns Key, Capacity. For example, I have created a test cube with this data. Please read more about that here - Data from Jira. eazyBI would import only currently used statuses in the cube. It always says something I am continuing to develop an S-Curve based on weight status of issues. . S. Before diving into the creation of complex reports and calculations, it's essential to understand the concept of a multi-dimensional data cube and its building blocks. 39 1920×926 101 KB. And the report I’m new to eazybi and have tried deconstructi I have 4 issue statuses that I need to display on a bar graph by month. In reading the documentation you give an example of code to create a new linked Dimen There can be only one date/date-time dimension in the eazyBI “Issues” cube, and there is already a “Time” dimension with that data type out-of-box. Screenshot 2023-07-10 at 16. I think the best way is for my context (non-Agile) is to use dates from Fix Versions. Data import creates the data cube and ensures that imported data is organized in a more report-friendly structure. I am open to suggestions of other ways to accomplish the same thing, but am close to accomplishing what I want with this method - which importing the weekly targets and defining a custom cumulative measure. Listed values - issue statuses, Hi, I understand I can left click and then click on “Go to source” when working with the issue cube, however I would like to be able to create an additional column with a clickable URL in it. Share. Each eazyBI account contains a separate set of imported Jira project data, which can be accessed by eazyBI account users (access to eazyBI account data is managed separately from Jira security schemes). Hi, I’m trying to import additional data (REST) into the Jira data cube, but somehow EazyBI cannot map the user field from the JSON to the Assignee dimension. My question is: Is it possible to make a report from data obtained from two applications? In this case, I generated a cube with data obtained through a Rest: Api from JiraDesk, and another cube with JiraSoftware data obtained with the source application “JIRA”. You may import application data in a separate cube, where you define all needed dimensions. In eazybi we have a custom dimension for a custom dropdown field that we have in jira called Resource Group. Filter rows by Test Plan Start date; choose the option > and enter a relative period like 6 months ago to run the report for a limited time frame. This way you can import new measures and new properties to Issue dimension members. See this Community post for calculation: Get issues that have two Hello, I am trying to import a big google sheet, but I get the same error message on and on “Missing dimension member for (it gives me a specific key”) and new Hi all. E. In eazyBI, we try to find a suitable workaround - for instance, use some common field to map and import data in the same cube (at least, partly). I amb using the following custom fields as dimension in the Source Aplication JIRA: After importing the issues Additional data import into Confluence cube. Jira provides REST API to access the audit log records allowing the creation of many useful All eazyBI for Jira eazyBI for Confluence Private eazyBI A tuple is a collection of member(s) with the restriction that only one member in the tuple can be from the same dimension. eazyBI log files. Hi @Tomasz,. Debugging and extracting data using JSON to ensure you’re pulling the correct values. Martins / eazyBI. In the report Just guessing: eazyBI imports data into the cube on a scheduled basis - so it’s not really real-time. For Example i have the Labels “Label1” and “Label2”. To reduce import time and the testing data in the I have a calculated member as follows: Cache( sum({PreviousPeriods([Time]. yqzl aciyo qvwtrx qtkfje kpnip dblj jhyfdxil wie gvizajj ruhrjt