Report script not returning results

Report script not returning results

Barry Nuckolls
Barry Nuckolls

July 11th, 2011, 1:25 pm #1

Hello all, I need a script/query for extracting level 0 data from an ASO cube in a format that is loadable into another system. I have coded an mdx script that returns results, but I would rather use a report script for a number of reasons. Below is an attempt at the report script. The page members match the where clause members in the mdx script and the column and row members match as well. Anyway, the report script never returns results. Does anyone see anything glaringly wrong with this script?

//ESS_LOCALE English_UnitedStates.Latin1@Binary

<PAGE(View, Currency, Year, Scenario, Source)
Monthly Local &MPC_CY ACTUAL GENERAL_LEDGER

<COLUMN(Period)
<DIMBOTTOM "Period"

<ROW (channel,"cost center", entity, location, account)
<DIMBOTTOM "channel"
<DIMBOTTOM "cost center"
<DIMBOTTOM "entity"
<DIMBOTTOM "location"
<DIMBOTTOM "account"

<SUPSHARE
{SUPMISSINGROWS}
{SUPALL}
{TABDELIMIT}
{NOINDENTGEN}
{ROWREPEAT}
{DECIMAL 4}
Reply
Share

Joined: November 26th, 2001, 10:15 pm

July 11th, 2011, 2:25 pm #2

And see if that works.

My guess is that Essbase never comes back with the answer because the report set is so big.

Prove first that the report script works, then focus on performance.

Regards,

Cameron Lackpour

Reply
Like
Share

Joined: October 13th, 2010, 11:33 am

July 11th, 2011, 10:48 pm #3

Hello all, I need a script/query for extracting level 0 data from an ASO cube in a format that is loadable into another system. I have coded an mdx script that returns results, but I would rather use a report script for a number of reasons. Below is an attempt at the report script. The page members match the where clause members in the mdx script and the column and row members match as well. Anyway, the report script never returns results. Does anyone see anything glaringly wrong with this script?

//ESS_LOCALE English_UnitedStates.Latin1@Binary

<PAGE(View, Currency, Year, Scenario, Source)
Monthly Local &MPC_CY ACTUAL GENERAL_LEDGER

<COLUMN(Period)
<DIMBOTTOM "Period"

<ROW (channel,"cost center", entity, location, account)
<DIMBOTTOM "channel"
<DIMBOTTOM "cost center"
<DIMBOTTOM "entity"
<DIMBOTTOM "location"
<DIMBOTTOM "account"

<SUPSHARE
{SUPMISSINGROWS}
{SUPALL}
{TABDELIMIT}
{NOINDENTGEN}
{ROWREPEAT}
{DECIMAL 4}
Are you ending the script with "!" ? That tells the kernal to execute.

Dave
Reply
Like
Share

Anonymous
Anonymous

July 12th, 2011, 1:24 am #4

Dave, I forgot to copy/paste the bang, but it is there, at the end of the report script. Thanks for the reply though.
Reply
Share

Joined: November 16th, 2003, 11:27 pm

July 12th, 2011, 1:35 pm #5

Hello all, I need a script/query for extracting level 0 data from an ASO cube in a format that is loadable into another system. I have coded an mdx script that returns results, but I would rather use a report script for a number of reasons. Below is an attempt at the report script. The page members match the where clause members in the mdx script and the column and row members match as well. Anyway, the report script never returns results. Does anyone see anything glaringly wrong with this script?

//ESS_LOCALE English_UnitedStates.Latin1@Binary

<PAGE(View, Currency, Year, Scenario, Source)
Monthly Local &MPC_CY ACTUAL GENERAL_LEDGER

<COLUMN(Period)
<DIMBOTTOM "Period"

<ROW (channel,"cost center", entity, location, account)
<DIMBOTTOM "channel"
<DIMBOTTOM "cost center"
<DIMBOTTOM "entity"
<DIMBOTTOM "location"
<DIMBOTTOM "account"

<SUPSHARE
{SUPMISSINGROWS}
{SUPALL}
{TABDELIMIT}
{NOINDENTGEN}
{ROWREPEAT}
{DECIMAL 4}
Use query designer in the addin to create the extract that you want. Save the query and then open the .rep file QD creates. That will be your report script.
Reply
Like
Share

Sean V
Sean V

July 12th, 2011, 1:56 pm #6

Hello all, I need a script/query for extracting level 0 data from an ASO cube in a format that is loadable into another system. I have coded an mdx script that returns results, but I would rather use a report script for a number of reasons. Below is an attempt at the report script. The page members match the where clause members in the mdx script and the column and row members match as well. Anyway, the report script never returns results. Does anyone see anything glaringly wrong with this script?

//ESS_LOCALE English_UnitedStates.Latin1@Binary

<PAGE(View, Currency, Year, Scenario, Source)
Monthly Local &MPC_CY ACTUAL GENERAL_LEDGER

<COLUMN(Period)
<DIMBOTTOM "Period"

<ROW (channel,"cost center", entity, location, account)
<DIMBOTTOM "channel"
<DIMBOTTOM "cost center"
<DIMBOTTOM "entity"
<DIMBOTTOM "location"
<DIMBOTTOM "account"

<SUPSHARE
{SUPMISSINGROWS}
{SUPALL}
{TABDELIMIT}
{NOINDENTGEN}
{ROWREPEAT}
{DECIMAL 4}
"Never returns results"

as in just keeps on running or returns an empty set?
Reply
Share

Cameron Lackpour
Cameron Lackpour

July 12th, 2011, 3:07 pm #7

Hence the "pick a single member from each dimension to prove the report works" suggestion.

The OP has yet to confirm that it's a valid script.

Regards,

Cameron Lackpour
Reply
Share


Confirmation of reply: