API tools faq
paste
Guest User

Untitled

a guest
Jul 13th, 2018
117
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.53 KB | None | 0 0
raw download clone embed print report
  1. 2012-03-22 18:31:16,567 DEBUG [org.saiku.web.service.SessionService] Logging in with [org.springframework.security.core.userdetails.User@586034f: Username: admin; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_USER]
  2. 2012-03-22 18:31:27,403 DEBUG [org.saiku.web.rest.resources.QueryResource] TRACK /query/215C4D05-7487-6EF0-C71B-0D754C54C48E POST xml:false
  3. 2012-03-22 18:31:27,414 INFO [org.saiku.olap.util.SaikuProperties] Saiku: properties loaded from 'file:/home/saiku/saiku-server-2.3/tomcat/webapps/saiku/WEB-INF/classes/saiku.properties'
  4. 2012-03-22 18:31:27,414 INFO [org.saiku.olap.util.SaikuProperties] Saiku: loaded 0 system properties
  5. 2012-03-22 18:31:27,443 DEBUG [org.saiku.web.rest.resources.QueryResource] TRACK /query/215C4D05-7487-6EF0-C71B-0D754C54C48E/result POST WITH SET [FDMA] AS {{[Geo].[32]}}
  6. SET [FLoc] AS {[Geo].Location.[8], [Geo].Location.[9], [Geo].Location.[10], [Geo].Location.[11], [Geo].Location.[12], [Geo].Location.[13], [Geo].Location.[14], [Geo].Location.[15], [Geo].Location.[16], [Geo].Location.[17], [Geo].Location.[18], [Geo].Location.[19], [Geo].Location.[20], [Geo].Location.[21], [Geo].Location.[22], [Geo].Location.[23], [Geo].Location.[24], [Geo].Location.[25], [Geo].Location.[26]}
  7. SET [MUHierarchy] AS {Hierarchize({{[Menu Item.default].[Meal Part].Members}, {[Menu Item.default].[Course Category].Members}, {[Menu Item.default].[Product].Members}, {[Menu Item.default].[Menu Item].Members}, {[Menu Item.default].[Menu Size].Members}})}
  8. SELECT
  9. NON EMPTY Hierarchize({[FDMA], filter([FLoc], [Geo].Location.CurrentMember.Parent IN [FDMA])}) ON COLUMNS,
  10. NON EMPTY
  11. Hierarchize(
  12. Union(CrossJoin([MUHierarchy], {[Measures].[AveragePrice]}),
  13. Union(CrossJoin([MUHierarchy], {[Measures].[Is LTO]}),
  14. Union(CrossJoin([MUHierarchy], {[Measures].[Is Deleted]}),
  15. CrossJoin([MUHierarchy], {[Measures].[Is New]}))))
  16. ) ON ROWS
  17. FROM [PriceMonitor]
  18. WHERE {Hierarchize({([Company].[823], [Period].[2011_1])})}
  19. 2012-03-22 18:31:28,498 INFO [org.saiku.service.olap.OlapQueryService] Size: 0/0 Execute: 1040ms Format: 5ms Total: 1045ms
  20. 2012-03-22 18:31:28,508 DEBUG [org.saiku.web.rest.resources.QueryResource] TRACK /query/215C4D05-7487-6EF0-C71B-0D754C54C48E DELETE
  21. 2012-03-22 18:31:28,525 DEBUG [org.saiku.web.rest.resources.QueryResource] TRACK /query/5EAABBF2-F895-6963-17F1-56692CEF07D6 POST xml:false
  22. 2012-03-22 18:31:28,530 DEBUG [org.saiku.web.rest.resources.QueryResource] TRACK /query/5EAABBF2-F895-6963-17F1-56692CEF07D6/result POST SELECT
  23. NON EMPTY Hierarchize({{[Geo].[32]}}) ON COLUMNS,
  24. NON EMPTY [Product].[Meal part].Members ON ROWS
  25. FROM [PriceMonitor]
  26. WHERE {Hierarchize({([Company].[823], [Period].[2011_1])})}
  27. 2012-03-22 18:31:28,568 INFO [org.saiku.service.olap.OlapQueryService] Size: 2/7 Execute: 21ms Format: 16ms Total: 37ms
  28. 2012-03-22 18:31:28,575 DEBUG [org.saiku.web.rest.resources.QueryResource] TRACK /query/5EAABBF2-F895-6963-17F1-56692CEF07D6 DELETE
  29. 2012-03-22 18:31:32,054 DEBUG [org.saiku.web.rest.resources.QueryResource] TRACK /query/57112031-8D7F-6D38-529A-904CD3BEA850 POST xml:false
  30. 2012-03-22 18:31:32,059 DEBUG [org.saiku.web.rest.resources.QueryResource] TRACK /query/57112031-8D7F-6D38-529A-904CD3BEA850/result POST WITH SET [FDMA] AS {{[Geo].[32]}}
  31. SET [FLoc] AS {[Geo].Location.[8], [Geo].Location.[9], [Geo].Location.[10], [Geo].Location.[11], [Geo].Location.[12], [Geo].Location.[13], [Geo].Location.[14], [Geo].Location.[15], [Geo].Location.[16], [Geo].Location.[17], [Geo].Location.[18], [Geo].Location.[19], [Geo].Location.[20], [Geo].Location.[21], [Geo].Location.[22], [Geo].Location.[23], [Geo].Location.[24], [Geo].Location.[25], [Geo].Location.[26]}
  32. SET [MUHierarchy] AS {Hierarchize({{[Menu Item.default].[Meal Part].Members}, {[Menu Item.default].[Course Category].Members}, {[Menu Item.default].[Product].Members}, {[Menu Item.default].[Menu Item].Members}, {[Menu Item.default].[Menu Size].Members}})}
  33. SELECT
  34. NON EMPTY Hierarchize({[FDMA], filter([FLoc], [Geo].Location.CurrentMember.Parent IN [FDMA])}) ON COLUMNS,
  35. NON EMPTY
  36. Hierarchize(
  37. Union(CrossJoin([MUHierarchy], {[Measures].[AveragePrice]}),
  38. Union(CrossJoin([MUHierarchy], {[Measures].[Is LTO]}),
  39. Union(CrossJoin([MUHierarchy], {[Measures].[Is Deleted]}),
  40. CrossJoin([MUHierarchy], {[Measures].[Is New]}))))
  41. ) ON ROWS
  42. FROM [PriceMonitor]
  43. WHERE {Hierarchize({([Company].[823], [Period].[2011_1])})}
  44. 2012-03-22 18:31:33,422 INFO [org.saiku.service.olap.OlapQueryService] Size: 9/1078 Execute: 1036ms Format: 327ms Total: 1363ms
  45. 2012-03-22 18:31:33,750 DEBUG [org.saiku.web.rest.resources.QueryResource] TRACK /query/57112031-8D7F-6D38-529A-904CD3BEA850 DELETE
  46. 2012-03-22 18:31:33,926 DEBUG [org.saiku.web.rest.resources.QueryResource] TRACK /query/F612653F-2BF9-821E-5B9E-CDA9057BEDBD POST xml:false
  47. 2012-03-22 18:31:33,929 DEBUG [org.saiku.web.rest.resources.QueryResource] TRACK /query/F612653F-2BF9-821E-5B9E-CDA9057BEDBD/result POST SELECT
  48. NON EMPTY Hierarchize({{[Geo].[32]}}) ON COLUMNS,
  49. NON EMPTY [Product].[Meal part].Members ON ROWS
  50. FROM [PriceMonitor]
  51. WHERE {Hierarchize({([Company].[823], [Period].[2011_1])})}
  52. 2012-03-22 18:31:33,934 INFO [org.saiku.service.olap.OlapQueryService] Size: 2/7 Execute: 4ms Format: 1ms Total: 5ms
  53. 2012-03-22 18:31:33,938 DEBUG [org.saiku.web.rest.resources.QueryResource] TRACK /query/F612653F-2BF9-821E-5B9E-CDA9057BEDBD DELETE
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!