Self Service Reporting - Latest Released

オフライン

I need to pull a report but only for latest released however it seems SSR can only pull current?

I've tried messing around with filters on the is_current and is_released properties but when set to 1 and latest isn't one of these I don't get the expected result.

Suggestions?

Parents Reply Children
  • 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. 

  • オフライン in reply to AngelaIp

    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....

  • オフライン in reply to kaftab

    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.

  • オフライン in reply to AngelaIp

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

  • オフライン in reply to Morgan

    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.