Skip to Content
author's profile photo Former Member
Former Member

aggregates based on ficed value of attribute

Hi,

Is it possible to build an aggregate based on a fixed value of an attribute? I tried building one, however it does not allow me to include the main characteristic to which the attribute belongs to.This particular aggregate is not picked up while executing the queries, as the main characteristic is not included.Please let me know if there is a way I can assign a fixed value to an attribute.

Thanks

srishti

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2005 at 01:16 PM

    Have you tried using the Expoert Mode under the Extras menu option. That should allow you to have the characteristic and one ( and I believe only one ) attribute in the aggregate.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 20, 2005 at 07:12 PM

    Srishti,

    When defining the aggregate all characteristics in your dimensions, and all navigation attributes that are active for this cube are shown on the left selection panel. You can drag over the the navigation attribute and then restrict it to a single value, all values, or a hiearchy node selection. Regular attributes of characteristics are not available for aggregates.

    Hope I understood you question correctly.

    Kevin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 20, 2005 at 08:14 PM

    Hi,

    I'm sorry. Let me put it this way. I have a navigational attribute to which I'd like to assign a fixed value. However, I'm unable to add the main characteristic along to the aggregate. The aggregate gives me a choice to pick either the navigational attribute or the main characteristic.But I'd like to build an aggregate looking exactly like the cube however with a fixed value of a navigational attribute.

    Thanks

    Srishti

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.