tag:blogger.com,1999:blog-7650953985627040991.post10569956059772579..comments2024-02-14T05:30:55.538-05:00Comments on Cameron's Blog For Essbase Hackers: Stupid Planning queries #4 -- VersionCameron Lackpourhttp://www.blogger.com/profile/07701786303677521318noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7650953985627040991.post-6004710569221641992011-08-29T06:57:33.268-04:002011-08-29T06:57:33.268-04:00Indra,
What you're talking about is different...Indra,<br /><br />What you're talking about is different than these dimension queries (I do have a few more to go through) -- you're referring to *data* queries. <br /><br />There's all sorts of data in Planning:<br />* SmartLists as stored in data<br />* Cell text<br />* Supporting detail (probably the big one)<br />* Dates<br />* I'm sure there's something I'm missing<br /><br />The trick for FR is that it marries up the above data when needed with the Essbase data as required. You'd have to write a reporting framework that does the same. I don't know how Planning data sources really work (is there some kind of intelligent indexing scheme that identifies Planning data on a retrieve and joins the Planning data to Essbase or is it dumb and retrieves both sides every time? Hopefully the former, but you never know.<br /><br />I do know that FR and Planning data sources are slower than Essbase and that, in 11.1.2.0 at least, there are a fair number of bugs with Planning data sources and FR. <br /><br />I posted a Supporting Detail query to the OTN Planning board (I don't frequent it all that much) some time ago -- I know others have as well.<br /><br />I'll think about how I could best write a series of queries (rhymes, nice) to get data out. But I have to finish the metadata series first.<br /><br />Regards,<br /><br />Cameron LackpourCameron Lackpourhttps://www.blogger.com/profile/07701786303677521318noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-89915115061665699182011-08-18T03:33:31.561-04:002011-08-18T03:33:31.561-04:00Hi, Cameron. Have been reading the 4 part of your ...Hi, Cameron. Have been reading the 4 part of your queries related with planning. <br />I've been trying to find ways to query the use of smartlist with the account dimension.<br />As you may know, we can only see the smartlist/text and not the essbase data if we are using FR with Planning ADM. If there's a way to query directly to planning, that would be great. <br /><br />Regards,<br /><br />IndraIndra Bangsawanhttps://www.blogger.com/profile/03347451858756168327noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-53020892666890060302011-08-18T03:33:09.200-04:002011-08-18T03:33:09.200-04:00This comment has been removed by the author.Indra Bangsawanhttps://www.blogger.com/profile/03347451858756168327noreply@blogger.com