Thanks very much for the help, I can report success with the basic connection! Loading the PowerBI template generates a very large number of errors which I'm assuming is down to the limited data population of my environment, however, the one specific thing I would like to check on though is that a ...

Hi, still no joy I'm afraid, I've followed the steps a number of times and within PowerBI first get asked hot to connect, i then go to edit credentials which shows the connector with anonymous, then it tries to connect and I get an error saying it cant connect with the credentials provided. I've te...

Hi, I'm a new Essential Cloud user and haven't been a developer for many years, so struggling to work through why I can't get this to work. I'm getting a credentials error when running the connector query. I'm assuming the username is the full email address to log-in to the platform, or have I miss...

Looks like v6.11 release may have broken the connector (at least it's stopped working for me) - I'll get it working again my end, and then we can troubleshoot if still an issue.

I don't know if they'll be minuting their discussions in any fashion, but i wonder if some of the discussion would be of benefit across to users from other industries. Could you find out what they might be willing to share?

FYI - Latest Power BI update looks like some incredibly useful features that can be taken advantage of Full update Info here : https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2020-feature-summary/ Q&A Field synonyms for Q&A - good when multiple terms are used to mean the same ...

Hi Chris, for those of us unable to use powerbi, would it be possible for you to post some screenshots demonstrating the kind of reports you defined through the connector ? Either here or on github ? Thanks, Jean-Marie. I've also included a gif showing the ease with which these can be pulled togeth...

Also, (as I forgot this earlier) You can bring in Visio visuals, but they are a little more limiting/complicated (depends on sharepoint/visio web services) In this simple example, visio block elements use data in PowerBI from EAS to colour-code and place text about lifecycle status EA_9.png You can ...

How you bring all these bits and pieces onto a single page/dashboard will depend on the "message" or "story" that page is designed to tell... Which is where my hope lies, by sharing this proof of concept, we all can build on it and share "this worked for me with my <insert u...

Trying out other visuals to show Technical Debt
Another Overview Dashboard
A view of the latest Data Model (bits of Metamodel from EAS that i've brought into PowerBI)

Basic GIS View Calendar visuals Basic Dashboards

Hi Chris, for those of us unable to use powerbi, would it be possible for you to post some screenshots demonstrating the kind of reports you defined through the connector ? Either here or on github ? Thanks, Jean-Marie. Sure, I'll probably get around to posting in GitHub in due course! Firstly, we ...

v2.0 of the PowerBI Dashboard is now released, Until such time it's merged with Master it can be found under the Pull request https://github.com/essentialproject/essential-contributions/pull/3/files You should find all the necessary PowerBI concepts and ideas to produce what you need (there's exampl...

v2.0 of the PowerBI Dashboard is now released, Until such time it's merged with Master it can be found under the pull request https://github.com/essentialproject/essential-contributions/pull/3/files You should find all the necessary PowerBI concepts and ideas to produce what you need (there's exampl...

Hi Chris, We're a new user of EA cloud. This will no doubt be extremely useful. My plan is eventually to allow our analytics team to own the design and build of the dashboards so the pain doesn't sit with IT to build new EA viewer views, however, I suspect it will be a mix. On that note, do you hav...

Thx Jason, I'll give that a go, let you know how it works out.

Is anyone modelling regulatory bodies and how they map to the business model (which business units/regions they apply to, regulated applications etc.) I'm thinking things like mapping PCI-DSS impacting our Customer Account Management system, across all regions etc. If so, could you explain how you'v...

FYI - in case you missed it in the other subforum : https://www.enterprise-architecture.org ... =23&t=2399

@Jason

Sounds good -

Will 6.11 also update the value stream view so that the capabaility name(s) will show appropriately ?

Chris

I believe I read that you need to zip the xsl files and then attach the zip.

This work has a new home https://github.com/essentialproject/ess ... tributions

The old repo will be retired.

Thanks @NeilWalsh for setting this up

Nice - i've pushed into working page here - https://github.com/C-Losch/essential_vi ... ummary.xsl

Hoping this might also help : Have at the Power BI report i published to the community (More info on it here : https://www.enterprise-architecture.org/forums/viewtopic.php?f=23&t=2399) Here's an example of the type of report you're asking about done in PowerBI (takes <5 mins to construct - and h...

I've updated Revision of the PowerBI template to make it TenantID agnostic (you'll be prompted for tenantID) and also make it "user friendly" by hiding and renaming fields/classes to something more understandable by those less familiar with the metamodel. Feedback welcomed - also, let me k...

Neil, I'm not an expert in Git/Open Source contribution concepts, but for some time i've felt a shortfall for the community to be able to rapidly share ideas/views/customisations, so I've spawned <removed> - edit: new vendor provided location https://github.com/essentialproject/essential-contributio...

Cheers John, I'll have a look see if i can wrap my head around it (as an amateur in the systems integration/dev world)

It'd be great if the Utility API Docs/Postman examples were up alongside the core-api https://api.enterprise-architecture.org/?version=latest - but I've got the PDF for now

The above Repo now includes PowerBI template https://github.com/essentialproject/ess ... rs/PowerBI

edit: new location

So i've created a Community source code Repo here https://github.com/essentialproject/ess ... tributions You can find the Custom Connector Source Code here : https://github.com/essentialproject/essential-contributions/tree/master/connectors/PowerBI I'll post the PowerBI Template up there too a bit l...

Update

So I've written a Custom Connector which works with the OAuth2 (bearer token etc.) - whilst functional, it may not be the most elegant way but as a PoC its fine. Those interested can reach out and i'll share.

Chris

Thought I'd ask around - I've a PowerBI Dashboard, currently linking key parts of the MetaModel around to aid with more dynamic creation of reports. Couple of questions 1. Is anyone else using Power BI and wants to compare notes on what they're using it for - as well as any example reports? Current ...

Hi, the editors are a great addition. Would be great to be able to capture in the project editor the Change Activities planned changes. +1, I agree - we can use https://essentialviewer.com/demo/report?XML=reportXML.xml&XSL=enterprise/core_el_strategy_planner.xsl&LABEL=Strategy%20Planner&...

Firstly it'd be great if there were some pre-baked integrations, where you just enter the credentials/keys and select the data you want and direction as many other SaaS packages now offer (maybe something for the future) However, we've performed integrations using Talend Open Studio (free) as the in...

Hi Colin,

Understood, I can appreciate that may be no small undertaking - any effort is appreciated.

@EAS - We could really do with a custom view sharing repo where we can build on eachohers views.

Chris

Hey Colin,

Sounds very interesting, are you able to provide a copy of the customisations?

Chris

Ah! Found it, cheers! (wasn't looking there)

Be good to add this on the Application Editor also, it'd be useful to enable ease of maintaining the APM Application Reference Model

However, the Technology Product Editor and Technology Type Editor, available to Essential Cloud users from the Essential Viewer, allows for the scoping of Technology Product Standard Specifications to specific Organisations as shown in the screenshot below. Hmmm, on our Essential Cloud I don't get ...

More feedback

To get a match on wildcard version
had to put * value in the Technology Provider Version slot - rather than a numerical value
expectation: numerical versions would match any numerical version (as appropriate

Performance is much improved (it's working now :) and quicker than 10 secs ) There's definitely something different about how we use Tech Product and Tech Product family that we'll need to adapt - just having a think about what that means for us - might be too granular for our needs to map every ver...

Hi John, Thanks for posting the update. Running this updated view with https://nvd.nist.gov/feeds/json/cve/1.1/nvdcve-1.1-2019.json.zip as cvedata.json causes the webbrowser to hit 100% cpu and hang for... well it's not come back in 5 mins, so i'm going to say forever. using it with https://nvd.nist...

thx for the update

Having the same problem, though i grabbed https://nvd.nist.gov/feeds/json/cve/1.1/nvdcve-1.1-2020.json.zip from https://nvd.nist.gov/vuln/data-feeds uploaded the above as data.json (unzipped of course) in the view I only get the option in 'Vendor' of .All Testing this against a Tech product of "...

ta

Hi All, As we start to model our business in the tool, running into some areas that require a bit of thought, perhaps two questions with a similar theme, which is "How granular should we be?". 1. Application Services As we map out the application estate, we run into the situation where an ...

+1