Your SAS programs, embedded in web apps and elsewhere

Stored Process as a Data Source for BI Dashboard 4.3

Reply
Contributor RSB
Contributor
Posts: 72

Stored Process as a Data Source for BI Dashboard 4.3

I am trying to figure out how to use a Stored process as a datasource for my Dashboard 4.3. I am publishing the output of the sas dataset to a package.

So far my Stp code looks like this.

%let _ARCHIVE_PATH = /Temp/;
%let _ARCHIVE_NAME = results;

data _null_;
rc = 0;
pid = 0;
desc = "";
call package_begin(pid, desc, nameV, rc);
%checkrc(Package init);
call insert_dataset(pid, "WORK", "MyData", "My Details",
'', rc);
%checkrc(Package data set);
length fullpath $4096;
call package_publish(pid, "TO_ARCHIVE", rc,
"archive_path, archive_name, archive_fullpath",
"&_ARCHIVE_PATH", "&_ARCHIVE_NAME", fullpath);
%checkrc(Package publish);
call symput('_ARCHIVE_FULLPATH', fullpath);
call package_end(pid, rc);
%checkrc(Package term);
run;

I am succesful in publishing the output of the STP as an spk file(I guess it is succesful since a .spk file is being generated) in the D: Drive, however when i select the stored process as the Datasource it is giving me a message "The Selected Stored Process Does not create any data sets".
Frequent Contributor
Posts: 80

Re: Stored Process as a Data Source for BI Dashboard 4.3

A spk file is an archive file, so think a .zip file.

The BI Dashboards needs a table as the data source (think SAS dataset).

Because you are effectively zipping the table, then the BI Dashboards can't read it.
Contributor RSB
Contributor
Posts: 72

Re: Stored Process as a Data Source for BI Dashboard 4.3

Thanks for the reply.

My Question was how to use the stored process as a data source for the Dashboard, not how to use the sas dataset.

For your Ref :
Section : Stored Process indicator Data in

http://support.sas.com/documentation/cdl/en/bidbrdug/63081/PDF/default/bidbrdug.pdf

However My Issue was resolved , All I have to do is turnoff the STP Macros (%STPBEGIN, %STPEND) in my Stored Process. and remove the explicit PATH.
Ask a Question
Discussion stats
  • 2 replies
  • 1629 views
  • 0 likes
  • 2 in conversation