Skip to Content
avatar image
Former Member

Strange folders in BoBj universe

Good Day everyone!

I have deployed OLAP cube based on MsSQL 2008 Analysis Services. I have made a connection with IDT, identified all measures and dimensions. Here everything is fine.

When I am trying to run report in WebI using CUSTOMER dimension, it displays me only limited number of raws. I have checked several time in settings that system must display unlimited number of raws, though it is not working. When I am trying to apply filter for CUSTOMER dimension, it shows me some weird FOLDER, that i do not have for sure in my Cube. I think that problem of limited raws is associated with the FOLDERS. It seems that the WebI limits the query based on these folders.

Have anyone faced similar problem? Please help!!

Capture.PNG (48.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 09, 2014 at 11:51 AM

    Hi

    If Object LOV's are huge, then system will bundle in the folder's

    Like LOV's , 1 to 10, then

    Folder A : 1- 3

    Folder B:  4- 6

    Folder C: 7- 10

    in the search box you can enter customer name then then press find, then you can bale to see customer name.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks! Like for example if i make a query to select top 3 customers by sales, it will return it, nevertheless they are not in the report?