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

Stored Process as a Data Source for BI Dashboard 4.3

RSB — Wed, 20 Apr 2011 07:27:59 GMT

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

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

ShaneGibson_OptimalBI — Sun, 24 Apr 2011 00:21:14 GMT

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.

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

RSB — Mon, 25 Apr 2011 12:26:25 GMT

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.