DMR Prompts -> OLAP Report filter

[rob.hollenbeck]

I have been asked to supply database-driven prompts that can be sent to multiple OLAP-sourced C8 report to filter and I'm running into more than the standard roadblocks

I'm baffled why I can run the data from my main query and it filters properly but can't run the report top level without an error

I can pass a dimension sourced from the database directly and it will work with  caption([LEVEL])=?Parameter1? but the DB QuerySubject Prompts don't present into the desired Tree Prompt

I have the same base Prompt table in a Regular Dimension Presentation that works with our hierachy and Tree Prompts and can

I can run View Tabular Data independently against my Prompt Query and Main report query successfully - the main even properly filters off the selected prompt values but I can't actually run report at the high level

Any insighnt or direction would be greatly appreciated

Thanks in advance


RSV-VAL-0010 Failed to load the report specification. OP-ERR-0025 The following OLAPPlanner internal error occurred: 'OPASSERT(this) in OPMetadata::DataSource::GetDatabaseIdType() at OLAPPlannerMetadataInterface.cpp:7329'.

[MFGF]

I have been asked to supply database-driven prompts that can be sent to multiple OLAP-sourced C8 report to filter and I'm running into more than the standard roadblocks

I'm baffled why I can run the data from my main query and it filters properly but can't run the report top level without an error

I can pass a dimension sourced from the database directly and it will work with  caption([LEVEL])=?Parameter1? but the DB QuerySubject Prompts don't present into the desired Tree Prompt

I have the same base Prompt table in a Regular Dimension Presentation that works with our hierachy and Tree Prompts and can

I can run View Tabular Data independently against my Prompt Query and Main report query successfully - the main even properly filters off the selected prompt values but I can't actually run report at the high level

Any insighnt or direction would be greatly appreciated

Thanks in advance


RSV-VAL-0010 Failed to load the report specification. OP-ERR-0025 The following OLAPPlanner internal error occurred: 'OPASSERT(this) in OPMetadata::DataSource::GetDatabaseIdType() at OLAPPlannerMetadataInterface.cpp:7329'.

Hi,

I'm not 100% clear on what you're trying to achieve here, but a couple of comments might help a little.

1. When you 'View tabular data' from your query, this produces a simple one-dimensional list so there are no OLAP-type intersections (tuples) to generate for the result set.  It is simply an indication of what the underlying data looks like, and does not necessarily guarantee that the result set (or its retrieval method) will be suitable for a multidimensional paradigm (crosstab, chart etc).

2. A Tree Prompt is intended for use with a dimensional hierarchy.  OLAP cube dimensions and DMR Regular Dimensions should work fine as sources for tree prompts, but plain old Query Subjects are not dimensional objects, and I would not expect to be able to source a tree prompt from one of these successfully.

Can you explain a little further exactly what you are trying to do?

Best regards,

MF.

[rob.hollenbeck]

We are a cube heavy organization but looking at doing more reporting with mixed database/cube reporting and trying to present consistant prompts hence the DMR sourced Tree Prompt that works well however I can't get the result passed to the main query

I understand the differences w/ "View Tabular Data" and the proper report output but I'm still baffled why it works as I want with the underlying data and not within a VERY simple sample crosstab (also checked with List)

The regular Database prompts function properly to pass parameters to two seperate cube-sourced crosstabs however don't give us the hierarchical flexabillity expected of standard cube-sourced tree prompts - I should think that the Reg DMR presnetation from that same table should pass through cleanly

Thanks for the feedback

[MFGF]

I can pass a dimension sourced from the database directly and it will work with  caption([LEVEL])=?Parameter1? but the DB QuerySubject Prompts don't present into the desired Tree Prompt

I'm still not clear on what the above actually means.  If you're trying to source a Tree prompt from a Query Subject, it will (and should) fail.  Can you explain again exactly what you're trying to do?

MF.

[rob.hollenbeck]

I have previously tried with a regular prompt using database query subject and tied OLAP source and filtered properly but that approach doesn't scale

Ideally we want to use Tree Prompts for our hierarchy and since cube-cube filtering doesn't behave enough I was trying DMR sourced Prompts to filter the OLAP source

My issue isn't with the Tree Prompt - I understand Cube or DMR but I need to get prompt result to more than one cube to filter cleanly

Thanks for following up - hopefully I've explained better this time

-rlh