[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
[JPIVOT] Problems with <VIEW> in schema Olap (SOLVED)  XML
Forum Index » Technical Help - SpagoBI Server - OTHER DOMAINS
Author Message
micmen.spw



Joined: 08/07/2010 13:11:20
Messages: 3
Offline

Hi, in my application I have defined a schema.xml containing 3 cube definition, one for each user category. To filter data on a custom profile attribute "userid" I define a Dimension as follow :



The problem is that when I login as Admin (the profile attribute "userid" is null or not corrisponding to user in table dim_medico) and query return empty resultset, an error occurs when I try to run or modify a query using this cube.
Thanks,
Michele.

This message was edited 3 times. Last update was at 08/07/2010 17:31:54

angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

Could you valorize the profile attribute "filter" of the administrator using a valid value for the column "codice_fiscale" ? If not you can valorize it with % and then modify the sql query as shown here ...



Let me know.

Regards

Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
micmen.spw



Joined: 08/07/2010 13:11:20
Messages: 3
Offline

Thanks, I apply this "patch" and now run well.

Regards,
Michele.
angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

gr8 :)

Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
 
Forum Index » Technical Help - SpagoBI Server - OTHER DOMAINS
Go to:   
Powered by JForum 2.1.9 © JForum Team