Self Service Reporting - Latest Released

Hi Morgan,

it´s been a while since I used SSRS. But your question sounds like a typical AML issue. You have to add an additional filter to your query to ensure you get all generations of an item. You either search for "generation greater zero" or "id is not null". 

Check out Chris´s answer in this post: https://community.aras.com/f/development/6593/aras-restful-api-how-do-i-get-a-list-of-all-generations-for-a-part . There is also a AML sample included you maybe can use for the report query.

Ciao

Angela

Silly question but, I don't see any obvious place to setup my report query with AML, only the graphics interface. Am I missing something?

To be honest, I am not sure where to add this one. Somewhere in the beginning you specify the used ItemType and select the properties you want to display. You should be able to specify a filter somewhere. 

I would add a filter for is_released=1 AND generation > 0  . And maybe "config_id is not null".

But I am just guessing. Better ask Aras support to get a more reliable answer!

As you use Self-Service Reports you probably have a subscription. In this case pay attention for the next Innovator version Innovator 24 which will appear pretty soon.

This one will introduce a complete new Reporting engine, which from my POV will replace the SSR completely over the long term run. When I have to make a prediction: The current SSR service (based on an external reporting software) will be set to EOL next year and you will be encouraged by Aras itself to update and switch to the new better Reporting variant. 

The current SSR service has a couple of limitations and was mainly a "first experimental approach" for Aras to build the QueryBuilder. 

I believe you can apply the condition here:

Btw, I was wrong with my Innovator 24 tip. It doesn´t seem to contain the new report service yet. Roadmap was misleading....

Can you use query builder to setup a self service report?

Not yet. Aras right now is working on the new report service that offers this feature. Not sure if it´s already included in Innovator 27 that comes this month. Keep an eye on the roadmap!

Current self-Service Reports were some kind of a test balloon for Aras. Some ideas of the Self-Service report (external engine!) were reused in their own Query builder. But they are not compatible.

Self-Service reports will be discontinued as soon as the new Report engine is available.

Thanks. I am currently looking for a way to get IDs in a report but that doesn't seem to be an option either.

Not exactly what you're looking for, but can you use the XLST reports? If you haven't, have a look at the Multi-levrl BOM View. That's not a self service system though.  Another option is to use MS SSRS. It works directly at the database level though. So you'll have to build your own access control logic in SQL. No AML. Again, not a self service system. 

Hope this helps. 

Regarding the id´s you maybe ask Aras if they know more. If you use this report tool you obviously have a subscription. 

Has somebody of you ever tried to generate Reports via the Prince engine (used for TDF) in Aras? Theoretically we could even connect it to the Query builder:

https://gist.github.com/YoannArasLab/f426a70affca0bfe0508abaa8f0c1656

I also have seen people using Power BI for reporting.

But I never tried any of these. I use the services described by Kaftab.