|
| Re: Adding new Dimensions to Data Cube and Cross Tab [message #741497 is a reply to message #741187] |
Wed, 19 October 2011 15:32   |
|
The quickest way I got your example to work was to right click on the
row dimension icon in the crosstab and click on show/hide group levels.
I checked the job title field and hit ok. I then repeated the process
and turned it off. The crosstab ran but the highlight did not work. To
make it work I turned job title back on and then just hid the data
element using visibility.
Jason
On 10/19/2011 5:14 AM, Aleksander Kruecken wrote:
> Hi,
>
> I'm having problems when I add a new Dimension to an existing DataCube and Cross Tab and then trying to add a highlight according to this new Dimension.
> In my example, I added a new Dimension JobTitle to Group2-Employenumber-Firstname-Lastname in my DataCube. So far everything is ok (I can see it in Data Cube).
>
> I then added a new Bind to my existing Cross Tab called 'JOBTITLE'.
> After that I added a Higlight in one of the Cross Tab cells (FIRSTNAME). In this step I could see it in a listbox Condition.
> data["JOBTITLE"] Equal to 'Sales Rep'
>
>
> But, when I preview the report I get an error 'The binding "JOBTITLE" refers to invalid levels.'
>
> Can you please tell me what I'm doing wrong?
>
> I can get the expected result when I create a new CrossTab from scratch (a new Collumn JOBTITLE appears in CrossTab which I do not want to show), but I can not afford to do it this way, because my report is changing often and is time consuming.
>
> Could you please look at my example in the attachment.
>
> Kindly regards,
> Aleksander
|
|
|
|
|
| Re: Adding new Dimensions to Data Cube and Cross Tab [message #904009 is a reply to message #903773] |
Mon, 27 August 2012 14:55 |
|
How did you remove Job title? Did you set visibility on the cell or the
data item? If you have an example that I can run, I may be able to spot
the problem.
Jason
On 8/25/2012 3:19 PM, birt user wrote:
> I have the same requirement. I have 2 crosstab reports, one source and
> another target and I am using drill through option. Taking your example
> I have to pass jobtitle from source report to target report. But I don't
> have to show job title in the source report. I followed instructions
> above but the crosstab output moves the columns to the left because of
> the empty column (job title removed) and breaks down everything. any
> tips how to make it work
|
|
|
|
Powered by
FUDForum. Page generated in 0.04299 seconds
] 
Search
Help
Register
Login
Home
