tag:blogger.com,1999:blog-7650953985627040991.post1819598808086960040..comments2024-02-14T05:30:55.538-05:00Comments on Cameron's Blog For Essbase Hackers: Cell Text exposure to OBICameron Lackpourhttp://www.blogger.com/profile/07701786303677521318noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7650953985627040991.post-33871921264406117482016-09-01T16:03:17.966-04:002016-09-01T16:03:17.966-04:00Cameron, His approach works fine as long as you ar...Cameron, His approach works fine as long as you are always exporting all periods. my approach does not care if you are exporting on period or 6 or 12. If I wanted to do this on SQL server I can use Cross apply in a view to get the data from columns to rows, but like his solution, it has to be a set number of columns for the periods. I can give you and example if you like and if does not need unionsGlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.com