Results 1 to 5 of 5

Thread: I am having one dimension

  1. #1

    I am having one dimension

    I am having one dimension with no jions , can i retrieve the data from that dimension?

    Question asked by visitor NARASIMHA

  2. #2
    Contributing Member
    Join Date
    Apr 2007

    Re: I am having one dimension

    ya sure can do that.for retrieving from a dimension(table) it is not necessary to have join on that.u can use simple select statement.

  3. #3
    Junior Member
    Join Date
    Nov 2008

    Thumbs up Re: I am having one dimension

    Ya sure why not.

    Bcz no need join.

    If the dimension is a part of Model we can publish with 1 Dimension also.

  4. #4
    Junior Member
    Join Date
    Dec 2008

    Re: I am having one dimension

    the question is not clear.. if there is two tables.. then u have to think about join.. one table.. how u r thinking in that prospective

  5. #5
    Junior Member
    Join Date
    Mar 2006

    Re: I am having one dimension

    If you have only one dimension in your model, then u can retrieve the data from that dimension.
    But if you have many dimensions in your model and only one dimension is not joined to any other dimensions in your model, then you have to be careful with your report development.

    Becoz, if you try to add query items from this unconnected dimension and any other dimension which is joined to fact, Report Studio trys to do a CROSS JOIN to display your report output.
    If CROSS JOINS are not allowed for your Model from with in FM, then Report Studio throughs up an Error saying: CROSS JOIN is not allowed between the columns used in your report.

    Hope this make things clear.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.