topic We just enabled ACM ETL Processing today - when will reports show in Report Center? in Administration and Deployment

We just enabled ACM ETL Processing today - when will reports show in Report Center?

rgreen33 — Thu, 03 Aug 2017 23:13:49 GMT

We just enabled ACM ETL Processing earlier today. When I go into Report Center, I only see the reports associated with the following:

Stored Processes -> System -> Applications -> SAS Environment Manager -> Ad Hoc Reporting

I am not seeing the Stored Processes -> Products folder at all. Am I missing someting, or will this automatically show up later, as the process collects data? In Environment Manager, I can see that data is being collected via the chart view under resources.

Do I just need to wait this out, or am I missing something that is probably the obvious?

Thanks,

Ricky

Re: We just enabled ACM ETL Processing today - when will reports show in Report Center?

JuanS_OCS — Fri, 04 Aug 2017 08:51:27 GMT

Hello @rgreen33,

I can think on several answers. One of them is that you are logging in with a user without enough permissions. Are you logging in with sasadm@saspw, just to be sure?

Those reports are stored processes, which means you can see them in SAS Management Console, but you can also run them anywere, such as with EG, or the SAS Stored Process web application, no only from the Report Center.

If the case is that even with sasadm@saspw you cannot see them, perhaps when you enabled ACM, it did not loaded all the Stored Processes, Perhaps you can check the logs of the enabling ACM, looking for messages of the spk import. Maybe something went wrong there.

Anyway, you can repeat the ACM load process anytime

Re: We just enabled ACM ETL Processing today - when will reports show in Report Center?

rgreen33 — Fri, 04 Aug 2017 11:13:27 GMT

@JuanS_OCS,

Thank you for your help. You were exactly right...my account didn't have access to view the report. I tried my unrestricted account and I can now see the reports!

Does this require "unrestricted" access? Or, is there a particular role that I could add to my normal account?

Thanks,

Ricky

Re: We just enabled ACM ETL Processing today - when will reports show in Report Center?

JuanS_OCS — Fri, 04 Aug 2017 11:17:39 GMT

Nah 🙂 You are the master of your system. But by default they are meant for Admins only. You can change the permissions on those stored process metadata to be available for additional users or groups. My suggestion: do not change permissions on each STP, just change the permissions on the folder that contains them.

Great that you can use them from now on!

Juan

Re: We just enabled ACM ETL Processing today - when will reports show in Report Center?

rgreen33 — Fri, 04 Aug 2017 11:20:52 GMT

@JuanS_OCS,

Perfect! Thanks again for your help.

Thanks,

Ricky