Help with Projected Plan Amounts

Project Plan Tables

I have an office yealy plan table, that is mostly static. Will I need to make this table a fact table and break this yearly plan number down by day using the time dimension to use it to calculate against all the facts in my fact table?

I have a fact table with all my daily submitted $ amounts per day, per office. I have a static "yearly office plan" table with my $$ per office per year. The thing is this "yearly office plan amount" could change based on business or sales and marketing decisions. I use this plan amount along with my fact table to base many mdx calculations against actuals vs plan, per day, per month etc.

FactPolicyTable hasolicyNumber(FK), DistributionChannelCode(FK), OfficeCode(FK), TimeKey(FK) and Face_amt, current_day_amt, lost_amt, prior_submitted_amt, pending_amt

DimOfficeTable has OfficeCode(key) and additional office information

PlanOffice table has keys of Plan_Office_Code(FK from OfficeCode), Plan_Office_Year, Plan Office Annual_Amt

The PlanOffice Annual Amt is what I need help with, how could I best implement this? all indications are I would have to break it down by day and move it into the FactPolicyTable or make it a fact table with a FK TimeKey in it. By the way this amount does not really relate to the PolicyNumber key in the fact table either.

I hope this gives you more to work with to help with my issue.

Or

Can I make this yearly plan amount a KPI? would the KPI still need to be broken down by day? can I use the KPI in to do calculations against other values in FactPolicy table?

What would be the best way to implement this Plan Value?

I hope I explained enough for this to make sense?

Well, the PlanOffice table could be a fact table for another measure group, which relates to the date dimension at a different granularity (ie. year) than does the FactPolicyTable (day). For example, in Adventure Works, the Sales Targets measure group relates to the Date dimension at the Calendar Quarter granularity, but [Measures].[Sales Amount Quota] gets allocated down to the month level in the cube MDX script.

Help with Projected Plan Amounts

Project Plan Tables

I have an office yealy plan table, that is mostly static. Will I need to make this table a fact table and break this yearly plan number down by day using the time dimension to use it to calculate against all the facts in my fact table?

I have a fact table with all my daily submitted $ amounts per day, per office. I have a static "yearly office plan" table with my $$ per office per year. The thing is this "yearly office plan amount" could change based on business or sales and marketing decisions. I use this plan amount along with my fact table to base many mdx calculations against actuals vs plan, per day, per month etc.

FactPolicyTable hasolicyNumber(FK), DistributionChannelCode(FK), OfficeCode(FK), TimeKey(FK) and Face_amt, current_day_amt, lost_amt, prior_submitted_amt, pending_amt

DimOfficeTable has OfficeCode(key) and additional office information

PlanOffice table has keys of Plan_Office_Code(FK from OfficeCode), Plan_Office_Year, Plan Office Annual_Amt

The PlanOffice Annual Amt is what I need help with, how could I best implement this? all indications are I would have to break it down by day and move it into the FactPolicyTable or make it a fact table with a FK TimeKey in it. By the way this amount does not really relate to the PolicyNumber key in the fact table either.

I hope this gives you more to work with to help with my issue.

Or

Can I make this yearly plan amount a KPI? would the KPI still need to be broken down by day? can I use the KPI in to do calculations against other values in FactPolicy table?

What would be the best way to implement this Plan Value?

I hope I explained enough for this to make sense?

Well, the PlanOffice table could be a fact table for another measure group, which relates to the date dimension at a different granularity (ie. year) than does the FactPolicyTable (day). For example, in Adventure Works, the Sales Targets measure group relates to the Date dimension at the Calendar Quarter granularity, but [Measures].[Sales Amount Quota] gets allocated down to the month level in the cube MDX script.

Help with large amount of text and page breaks

What has anyone done with large amounts of text in a table with regard to
page breaks? I've found that the page break happens before the large block
of text starts regardless of where it starts on the page. Even if there is
3/4 of the page empty it will always page break.
Here's an example. To illustrate, I'm just pulling back the Article Title
and the Article Details. I made the table background dark just so to
distinguish it from the rest of the page.
http://www.1uvaknd.com/pagebreaktest.pdf
This is in VS2003 preview mode. Take a look at page 2. The page size is huge
in comparison with the other pages.
http://www.1uvaknd.com/pagebreaktest_page1.jpg
http://www.1uvaknd.com/pagebreaktest_page2.jpg
http://www.1uvaknd.com/pagebreaktest_page3.jpg
Anyone else run into this?
Thanks
Richard.Richard,
We're having the exact same problem and can't seem to resolve it. I'm very
dissapointed there is no answer from MS to this question. If anyone out
there can think of anything please post.
I have found that if you use a list and get it set up just right it may
work. The problem is that you have to use a group and set a page eject at
the end of the group. If you have a unique item for the group it works ok.
One of our issues is that we want to use a field in the page footer which of
course isn't allowed (at least in the early versions).
--
Zip
"Richard Wodabek" wrote:
> What has anyone done with large amounts of text in a table with regard to
> page breaks? I've found that the page break happens before the large block
> of text starts regardless of where it starts on the page. Even if there is
> 3/4 of the page empty it will always page break.
> Here's an example. To illustrate, I'm just pulling back the Article Title
> and the Article Details. I made the table background dark just so to
> distinguish it from the rest of the page.
> http://www.1uvaknd.com/pagebreaktest.pdf
> This is in VS2003 preview mode. Take a look at page 2. The page size is huge
> in comparison with the other pages.
> http://www.1uvaknd.com/pagebreaktest_page1.jpg
> http://www.1uvaknd.com/pagebreaktest_page2.jpg
> http://www.1uvaknd.com/pagebreaktest_page3.jpg
> Anyone else run into this?
> Thanks
> Richard.
>
>|||Zip:
I can't believe I've not gotten any responses from MS on this from any SSRS
newsgroups. It is so easy to reproduce and so obviously wrong. I've gone as
far as to write a SQL function that will split up a text column into a
separate result set. It basically returns a bunch of rows. I then put the
table into a list object and it seems to work. The only problem is that the
function is limited to 8K and if your text is greater than that then it will
truncate. Not a perfect solution but still better than what is happening
now.
Richard.
"Zip" <gregory.zipprich@.arpc.denver.af.mil> wrote in message
news:F908AE27-97EF-4FC6-8C8B-1F796F12B085@.microsoft.com...
> Richard,
> We're having the exact same problem and can't seem to resolve it. I'm
> very
> dissapointed there is no answer from MS to this question. If anyone out
> there can think of anything please post.
> I have found that if you use a list and get it set up just right it may
> work. The problem is that you have to use a group and set a page eject at
> the end of the group. If you have a unique item for the group it works
> ok.
> One of our issues is that we want to use a field in the page footer which
> of
> course isn't allowed (at least in the early versions).
> --
> Zip
>
> "Richard Wodabek" wrote:
>> What has anyone done with large amounts of text in a table with regard to
>> page breaks? I've found that the page break happens before the large
>> block
>> of text starts regardless of where it starts on the page. Even if there
>> is
>> 3/4 of the page empty it will always page break.
>> Here's an example. To illustrate, I'm just pulling back the Article Title
>> and the Article Details. I made the table background dark just so to
>> distinguish it from the rest of the page.
>> http://www.1uvaknd.com/pagebreaktest.pdf
>> This is in VS2003 preview mode. Take a look at page 2. The page size is
>> huge
>> in comparison with the other pages.
>> http://www.1uvaknd.com/pagebreaktest_page1.jpg
>> http://www.1uvaknd.com/pagebreaktest_page2.jpg
>> http://www.1uvaknd.com/pagebreaktest_page3.jpg
>> Anyone else run into this?
>> Thanks
>> Richard.
>>|||Another (probably better solution). Put all the tables into a List
object. Then take the large text column out of the table and place it
in the list object itself. As long as the large text column is NOT in a
table but in a List object - it seems to work much better.
Richard.|||I'll have to try these solutions. Mine worked for some records and not
others. I think there are also special characters embedded that I can't see
and these are causing proglems. We plan on writing a procedure to strip out
all characters that are standard and see if that helps as well.
--
Zip
"richard.wodabek@.gmail.com" wrote:
> Another (probably better solution). Put all the tables into a List
> object. Then take the large text column out of the table and place it
> in the list object itself. As long as the large text column is NOT in a
> table but in a List object - it seems to work much better.
> Richard.
>