July 23, 2010 at 3:21 am
I have a report for a single child (the lowest level of the fact table)
The report uses an Analysis Services data set from a cube.
You should be able to look for a child by its ID. I set the Child ID as the paramter and go to the report. You have to choose the ID from the list and it takes forever to load. I just want someone to be able to type the ID, press go and find the child, NOT look through a massive list of child ID's.
Is there any way of setting the paramter to do this?
Debbie
July 23, 2010 at 7:43 am
Are you pulling the list of parameter values from a query?
July 23, 2010 at 8:06 am
I have the data set, set up in the Analysis Services data set creation pane.
I have the Child up at the top in the dimension window. I have checked the box to make it a parameter. This then creates an MDX table called...
ChildID that I can see in Parameters. the Default none queried value is
[Child].[ID].&[445545]
This then becomes my drop down box.
July 23, 2010 at 1:06 pm
If you want them to type a value in, without having to choose from the drop down list, don't feed the parameter with values from the query.
July 26, 2010 at 2:14 am
That was the first thing I tried.
In report Report Parameters I made available values None Queried and set default values to NULL.
Preview....
Add a child ID to the parameter box and I get this message...
An error occurred during local report processing,
Query Execution failed for data set ‘choose a child’s summary’
Query (1,827) the restrictions imposed by the constrained flag in the STRTOSET function were violated
August 25, 2010 at 4:10 am
Still no further with this one. :crying:
Would you say that if you want to go to the lowest level and parameterise a person its best to use the ROLAP data?
Or that I should be able to use the Cube and be able to just enter a pupil ID rather than select from a list
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply